Search results for query: *

Hello all; I have a db with secrity permissions for multi user access. The db sits on a server, and periodically I want to back it up and store it in another location. I first delete all the old tables, and then import all the tables with the data. The one issue is that all security permissions...

Hello all; I have a form (in Access 2000) where the user should enter a date. I need to ensure the user didn't leave the box empty. I did a Degug.print on this control when it is empty, and it returns Null. Yet, when I do If Me.shipDate = Null Then ..., it doesn't execute the Then part, meaning...

Hello All, I am using Access 2000 with service pack 3. Whenever I go to the VBA Module to code, or I use the Help feature, for some strange reason, the sound on my machine turns off, and will not turn on again untill I log off and log on again. (The Mute checkbox is not checked.) Any idea at all...

Hello all. I want to compare the value of a string expression entered by a user, with a second string, to test for equality. What function could I use to accomplish this? I looked through Access's help section with no luck. Any assistance would be appreciated. Thanks Steve

Hello All. I have a form which I set to display records based on a date, in descending order, like so: DateOrdered DESC. I used the Order By property, and it works fine. The problem is, I need to use this form ON another form, and when I drag it onto the other form, the sort order doesn't stay...

Hello all. I have a form with a subform. The subform coantains several records, and the view (for the subform) is Single Form. I have a button on the main form that performs certain functions when clicked, and then I want it to move to the next record of the subform. Anyone have an idea of what...

Hello all; I want to print my report a certain way every time, for ex. in Landscape mode, with the left and right margins set to only .25 inches. Any ideas on what code I could use to guarantee that it would print correctly each time? I saved the report in design veiw with the proper settings...

Hello all; I am trying to run an Insert Into statement from an event in an Access form, and I get the following error message: "Run-time erorr 3134. Syntax error in INSERT INTO statement." Here is my code: INSERT INTO Restock Orders (PONumber, DateOrdered) VALUES ('10048BO1'...

Hello all. I need an expression or function that returns Jan 1, of the current year. I know Year(date) returns the year, but I also neeed the Jan 1 part, becuase I need to test if the record in question occured in the current year or not. I don't want to hardcode the date, obviously. Any ideas...

Hello all. I have a calculated field in a query which I want to format to show only only whole numbers. Problem is, I need to test if another field used in the calculation is null, and if so, leave the field blank, NOT put in a zero. If I use an IIf statement to test for this, as so: Lbs Sold...

Hi all, I would like to have a textbox on a form where the user can enter the number of reports to print. I have a button which prints the report, created by the wizard, which has the following code: Dim stDocName As String stDocName = "PickTticket" DoCmd.OpenReport...

Hi all. I have a form with a subform. The OnExit event for the subform control tests for valid input from the user. If it's not valid, I want to disable the navigation and Close buttons (the X), with a Msg box instructing the user how to correct his error. I hid the navigation buttons by...

Hello all. Is there a way to change the error message which Access gives you when a user enters data into a table (or form) that doesn't conform to the input mask? The message "The value you entered isn't appropriate for the input mask 'whatever' " doesn't mean anything to a user who...

Hello all. Does anyone have any idea how to force a line break in a Msg box? Someone suggested Alt + Enter in the code where the text for the message is entered, but that didn't work. Any help would be appreciated. Thanks. Steve

Hello all. I have a main form and a subform. The subform has line items for a customer order. I have a unbound text box in the foooter to tally up one of the fields in the subform. I want to use that number to run a test when the user leaves The SUBFORM, meaning, the subform loses focus, (or so...

Hello All. I have a form which displays all customer orders. What I am trying to do is allow a user to enter a starting date and an ending date on another form, and the open my customer orders form based on that range of dates. My code is as follows: Dim filterStr As String Dim formToOpen As...

Hello all. I am creating some forms to be used in the Organizational Forms Library. How can I set the size for the form? Right now, it fills the whole screen, until the user minimizes it. However, I want to design the form to look a certain way, and it needs to be smaller. Any ideas would be...

Hello all. I have a db with a switchboard. I have made specific users for security, and not all users have access to all items on the switchboard. If a user has no access, a pop up box comes up, reading " There was an error using the command." How can I change the default message to...

Hi! What I am trying to do is as follows: I have a Data Entry form which allows the user to enter a customer order. I have a button which opens a second form, (entitled "Not Enough Form") displaying all items for which the order cannot be filled, because the inventory is too low. This...