Code:
Forms![Transactions]![Transaction Details Subform].[Form]![OrderStatusID]="1"
Code:
Forms![Transactions].Form![Transaction Details Subform]![OrderStatusID]="Confirmed"
DonRayner
Last Activity: Jul 21 '09, 11:41 AM
Joined: Sep 10 '08
Location: Canada
-
Your syntax is slightly off.
should be
-
Hi Deewe;
Welcome to Bytes.
Since the controls are not visible you can just move them up the form to be under the tab control and then not have to worry about them.
You could set the scroll bar property of the form to "neither" that way you wont have the scroll bars to scroll with. With the scroll bars off you don't have to worry about resizing the form. Just resize the forms window to display what...Leave a comment:
-
I created a form with “Time In”, “Time Out”,I’m able to calculate the Daily Hours correctly and it is displayed in a Calcuated Text box. How can i add these Text box hrs to another Text box which is weeklyhrs. To calculate the Gross pay per week
help.
Thank you -
Are you running anti-virus, I know McAfee's on access scan can slow things down somewhat.
Is it the application itself that is slow to open or the documents? IE:
Without word open how long does it take to open doc when you dbl click?
With word open how long does it take to open doc with file-open command and with a dbl click?Leave a comment:
-
How about some information on what type of hardware you are running and what your OS is? What version of Word and Excel are you running? The more information that you can provide the better your chance is of getting an answer to your question.
DonLeave a comment:
-
Did you try to disable UAC?Leave a comment:
-
Your VPN installer is probably an older msi installation package and some of the tasks that it needs to perform are requiring administration privileges. One thing you can try is to open up a command prompt with Run as Administrator option. Then run your setup program using msiexec.exe. The syntax for running it would be.
msiexec /i YourAppName.msi.
Other than that you could try disabling UAC.
Hope this...Leave a comment:
-
The connection between the computer and the cable modem is a local area connection. The computer won't see the internet until you establish the connection with the modem.Leave a comment:
-
In Word, you should just be able to ckick on the show/hide icon on the standard toolbar. It looks like this ΒΆLeave a comment:
-
You know you're going to have a good day when you've learned something new!!! Glad I could help.
DonLeave a comment:
-
You need to look at Conditional Formating for your field. In your report, right click on the price field and select conditional formating from the drop down menu.
DonLeave a comment:
-
should beCode:Date()-21
I would also change up the IIf to check for anything other than a zero length string instead of checking for a zero length string.Code:DateAdd("d",-21,Date()),
Code:IIf([Forms]![frmMoSel]![CBX_WED]>"",[Forms]![frmMoSel]![CBX_WED], >=DateAdd("d",-21,Date()))Leave a comment:
-
You can also get to Computer Management by right clicking on the My Computer Icon and selecting Manage....Leave a comment:
-
Questionit;
For the little that they cost, why don't you just pick-up a wireless router. Your router then would connect to the internet and the computers would connect to the router. You then wouldn't have one computer relying on another for access.
DonLeave a comment:
-
Hi OB;
I believe that the Vista sync center if for syncing Vista with mobile devices or folders on a network server. Did you try creating a briefcase and copying the files into that?
DonLeave a comment:
-
Are you pinging by name or by IP address?Leave a comment:
-
I'm not sure how to do it directly from a Batch file but you can use a vbs file to perform the task and call the vbs from the batch file. vbs(visual basic script). To create the vbs file just open notepad and create it like you would any other document. Save the file and then rename it. MyFile.txt would become MyFile.vbs
In your batch file you would then just call up the vbs file just like you would any other executable file.
...Leave a comment:
-
I had assumed that your computers were networked and that the backend mdb was located on one of them. Thats why I said to use the IP address for the path in the table link.
If they are you can get the computers IP address by going to a command prompt and typing "ipconfig /all" In the list that shows your IP address for the computer will be there.
So
\\ComputerName\ ShareName\Folde rName\FolderNam e\xxx.mdb...Leave a comment:
-
Hey OB;
After re-reading your problem, I think that the answer that you are looking for is the linked table manager. You can find it at Tools - Database Utilities - Linked Table Manager.
When using it put a check in the box on the lower left corner entitled "Always prompt for new location" Then click the "select all" button followed by by "ok".
You will then be prompted to navigate...Leave a comment:
No activity results to display
Leave a comment: