Search results for query: *

I am opening a .123 file in Lotus 123 version 9 and am getting the following error: The formula has too many nested levels or the @function has to many arguments. Divide the formula into smaller parts. My hunch is that this is an older lotus file, any clues? J.

hermanlaksko, Using your method, will this prevent certain users from accessing certains sections of the database? Or is it simply a username/password prompt? I need the security feature to restrict access to certain areas of the database. I can be emailed at jpaperwala(at)hotmail.com if...

LittleSmudge, I am concerned about one thing: If I place a shortcut as you suggested on everyone's desktop - are they all accessing the same frontend? I have had major problems with this, and that is why I have litterally copy and pasted the front end onto everyone's computer (as opposed to...

I have created a database (called front-end) that is linked to a bunch of tables (called back-end). I copy the front end to people's workstations where they can use their own database to link to the back-end tables. I want to implement security now - so I used the security wizard and followed...

I have a form that is shown continuously on the screen. If a user makes a change to one field on the form that currently has the control, I need another field (for that record) to be either enabled or locked (and remain that way - even if the person exits the form and comes back). However...

Hi Francescina, I am working with Access 2000 and would love to get the details of this program you have created. Would you please email me at jpaperwala(at)yahoo.com Thank you, J.

I've created a database that multiple people use. The front end (which I've copied to multiple people's desktop) is linked to a centralized database that is simply tables. I need to implement security on the front end database. So I set the security features through "Tools/Security/Etc...

I am trying to create a POS system in Access, and I want to purchase a Cash Drawer that will hooks up to a serial port. Does anyone know the command to open the cash drawer or how to program it in VBA to open the drawer when necessary?? Thanks for the help! J.

Andy, I can't do that. Those dates I gave you were for example purposes only. They usually need dates of 3/4 days later. It changes pretty much on a daily basis. They are entering information into a form and the info isn't always the same - which is why they created the macro. J.

The macro that they are using is just an autokey thing. Basically they use this macro to insert dates. For e.g. F1 = todays date = 05/21/02 F2 = tomorrows date = 05/22/02 F3 = yesterdays date = 05/20/02 They need to be able to be quick with inserting dates, so the person goes into the macro...

I have a macro that needs to be changed on a regular basis (the macro updates the F1 - F4 keys). I don't want the user to have access to the database menu where all the tables and queries are listed, but I need them to change the macro on a daily basis. Does anyone know if its possible to have...

I have code where the SQl statement does not fit on one line. can someone tell me how to make VBA in access recognize that the second line belongs with the first line? Thanks, J.

I have a Windows 2000 client, and want to configure Outlook to look at the Mail Server. I enter the path and it says "Network problems are preventing connection the Microsoft Exchange Server computer." But there are no network problems - I can access the server no problem. We are...

I have a report that I simply want to add a numbered list to. For example my report currently looks like this: Smith, John Jackson, Roberts King, Bill And I want to be able to do the following: 1. Smith, John 2. Jackson, Roberts 3. King, Bill 4. etc etc.. The information is pulled from a...

I tried that, but that doesn't work. I have to intergrate the string into the SQL code and the quotes are what is messing it up. Thanks, Julie

I have the following code and don't know how to incorporate the string that I need: "SELECT ... FROM ... WHERE (((ClientTable.ClientName) Not Like "TEST" ) AND ((Int1Table.Invoiced)=False) AND ((Int1Table.Received) Between #" & [Forms]![InvoiceForm]![FromDate] & "# And...

I have a query and that I need to change. So everytime I make a change and save it, all is fine. But once I run that query (the query is executed by a button on another form), it just gives me the old query - prior to making changes. The button that runs the query has an entire function that...

When I am in my database inputting information I sometimes get a message that says it will not save the stuff I have just done. Then I can't do anything so I get out of the form and try to go back in and then it says "You have cancelled your last opertion" and will NOT let me back...

Can someone tell me if there is a way to take specific data from a report and have access automatically insert it into a table? Thanks, Julie

Thanks JohnYingling - that worked nicely. I didn't know how to insert an if statement and get out of the do loop.. i.e. didn't know about the Exit Do statement. Thanks for your help, Julie