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...

FancyPrarie: Thanks! Your syntax is correct. (I should have known that one.) I appreciate the help! Steve

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...

Thanks. I'll check it out. Steve

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

annsolomon: Thanks for the idea. I'll give it a shot. Steve

Thanks. I'll try that. But why won't it work by simply dragging and dropping, if it workd fine standing alone? 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...

Someone suggested the Bookmark property. I made a clone of the recordset, and set the clone's Boookmark equal to form's Bookmark. Then, move the clone one record forward with MoveNext. Finally, set the form's Bookmark equal to the clone's Bookmark. That way, whatever record the user scrolls to...

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...

Thanks again, Zathras. Once again, your reply is on the money. I appreciate the assistance. Steve

pwise: Thanks for the link. I'll give it a try. RobBroekhuis: I didn't know there is a Macro recorder in Access. I thought it's only in Excel. Can you tell me where to find it? Thanks. Steve

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...

Zathras: I would give you five stars if I could! Thanks for saving my sanity. I really aprreciate it. I have another question though. I had a combobox that automatically looked up the record when the user choose an item. (This came thru the wizard). The field used to be a number, but I changed...

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'...

Zathras: I am using Access 2000, and I needed that function in a query I am using. Thanks again! Steve

Zathras: You pointed me in the right direction. However, the function you to use is DateSerial, not Date. (I got an error saying I had the incorrect number of arguments when I tried the date function). Thanks! Steve

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...

Thanks Omega36! Really appreciate it. With the Null instead of an empty string, the summation works fine. Thanks again! Steve