Search results for query: *

I have a line in the Close event of a modal pop up form which is designed to send a value to the control in the form from which the modal form pops up. The modal form is called up via the On_Click event of that control. The line in the Close event of the modal form that is creating the problem...

If there is another forum where this would be more appropriately posted please let me know. I am working as an independent contractor under an annually renewing services contract. I do all the IT work for this company which involves machine configuration, network configuration and security...

I have a from which has 2 combo boxes. The list for the second box is dependent upon the first box selection. The combo boxes are working properly. I have an unbound field which performs a DLookup based on the selection in the second combo box. If selections have already been made and the fields...

I am not sure how to go about this and I'm not sure if I can explain this very clearly either but here goes. I have a table that has item numbers no duplicates and a second table that has item manufacturing templates, of which there can be more than one per item number (one to many...

In Access 2000, I have a Receipt Form which allows the user in a particular control, to bring up a modal form using the Double_Click event of the control. The modal form provides for a numerical conversion and on closing sends the value to the same control from which the modal form was...

I have a problem with a SQL insert command. The command runs fine except when it encounters a piece of data that has an apostrophe ('). It looks as if the software is seeing that as a delimiter and returning a syntax error message. When I remove the character, the script runs fine. I can't...

The following code is producing a "missing semicolon at end of SQL statement" error. I can't seem to figure it out so I am asking for some help and possibly an explanation. Thanks in advance! Dim strSQL As String strSQL = "" strSQL = strSQL & "INSERT INTO ProductionBatchDetailTable" strSQL =...

I have a form (the first form) with data pulled from a table that is being used to create records in a different table (the second table). I am using a SQL insert command to place values from my first form into the fields in the second table. After the new record is created in the second table I...

I have this code attached to the BeforeUpdate property of an unbound field which is a fixed field set to zero decimals. I want the default for the field to show a zero (0) and have set that property accordingly. The code works properly when inputting anything into the field, but if the user...

I have a puzzling loop question. The code is below. The code inserts information which exists in the InventoryTransferForm into a table (InventoryTransferTable) and then proceeds to perform data manipulations of the form data to master data existing in a third table (ItemTable). The code works...

I am getting the infamous "Object variable or with block variable not found" message. I only get the error after responding to the message box with a Yes. A No response to the message box works fine. Also the error message does nor prevent the routine from running properly once I click the OK...

I have a form that has a text box that requires input which is often the result of a manual calculation related to liquid unit conversions. I know there are several different ways to approach this requirement, but I am wondering if someone can give me a solution that might involve an onscreen...

I am adding a second domain controller to a site for the purpose of replication for disaster recovery purposes. I have several questions that my research has not provided clear answers. This is a relatively simple network with AD primarily housing user names, passwords, and network shared...

I am running Windows Server 2003 Standard Edition RTM on a domain server and on a database server. Eliminating any application issues from the discussion, should I be upgrading these systems to SP2 or to R2 and then SP2. What is the significance of R2? I am having no issues with my current...

I am having a problem with a date parameter for a report. I have my parameters set to >= beginning date and <= ending date, but when I put the same date (mm/dd/yy format) in both fields my report yields nothing. I think this is because the date is time stamped with hours and minutes and perhaps...

I have cretaed a form driven menu system for an application that works independently of any menu bars or toolbars. Is there a way that I can disable and remove existing menu bars and toolbars so that only my form menus appear? Thanks for any help!!!

I have an unbound text box that, upon form processing, will be inserted into a table field. I want to limit the number of characters that the text box will allow to 80. How can I do this? Thanks for any help!!

In Windows XP SP2, is it possible to have different IP addresses for the same network adapter and have unique IP addresses linked to different user logon names through the user profile?

Can anyone tell me a method for disabling a device (network adapter) upon a specific user login? I am thinking of a login script or an environment setting tied to the user name. Profiles will not work because I do not want to require a reboot, just a login to a different user who is not allowed...

The code below is producing a "Too Few parameters. Expected 1" error. Item is a text field in the table and the form. I think my syntax might have an error. Any help would be appreciated. Thank you! Dim CurDB As Database Dim rs As recordset Set CurDB = CurrentDb Set rs =...