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.

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

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.

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

You guys have been great with helping me along... I was wondering if someone could take a look at this code and help me with the logic? I can't figure out how to get out of this procedure once it hits the LAST record. Once it gets to the last record, it looks at the next record and because...

I have a query that I am adding to.. After many attempts of trying to get the openrecordset command working, I am not having this problem: it doesn't for some reason add to the query on the first shot. I need to close the query and run it again and then it works. everytime after that works...

I get that error with the below code: Set rst = dbs.OpenRecordset("InvoiceQuery") strSQL = "SELECT Int1Table.InvoiceNumber, ClientTable.ClientName, ClientTable.ClientContact, ClientTable.Address1, ClientTable.Address2, ClientTable.City, ClientTable.Zip, Int1Table.FileNum...

I have a query that pulls up from a table (lets say for simplicity sake), a client code, file number, last name, first name and invoice number... CC, FN, LN, FN, IN 1 1 Smith, John, E123 1 2 Doe, Jane, E123 2 5 Renolds, Ron, E124 2 6 Black...

Too few parameters. Expected 2 When I have the following line: Set rst = dbs.OpenRecordset("InvoiceQuery") InvoiceQuery is a simple query with many columns... rst is a recordset and dbs is the currentdb.. any ideas?

I have a query that pulls up (lets say for simplicity sake), a client code, file number, last name, first name and invoice number... CC, FN, LN, FN, IN 1 1 Smith, John, E123 1 2 Doe, Jane, E123 2 5 Renolds, Ron, E124 2 6 Black, Joe, E124...

For those that have been helping me out. I really appreciate it.. I have an SQL statement that I need to close - it needs two )) at the end of it - I'm pretty sure.. Could someone follow the below code and possibly help? Thanks.. strSQL = "UPDATE Int1Table SET Int1Table.Invoiced = Yes...