Search results

I think you need to close your recordset prior to setting it again(except the first instance)

Either create a table from the database window, then delete the contents and reload with current data each time it is used or you could use a make table quiery. Most developers opt for the former. This is executed prior to openeing the report.

if your front end is secured and your back end is'nt then copy the fe, delete all objects, import tables, rename this as your back end. Now it is secure

So, what is the problem?

Convert the number to a string then format it in code. Infact create a function, pass the floating point number to it and return a string.

yes but place the code in the button's on click event not the form's on open event.

you need to look up the on change event for the text box. This fire every time a character is entered. then either use a filter, or better still create a query that uses the contents of the text box in a LIKE statement, and just requery the form in the on change event for the text box.

you can compact on close, and it may possibly be able to compact a closed db from an open one (not tried this). Just do'nt worry about the autonumbers as they should never be exposed to a user. try search this forum for members ideas on auto numbers. there are questions about this every week...

convert to a string, replace comma with full stop and convert back to floating point.

I've had a similar problem so I parsed the text file before importing it counting all the columns. So you could do something similar and if the last column was missing, read the text file again and add the column with null data.

how can you click the button on your form without opening the form? the form HAS to be opened in order to execute the on open event code. I sugest you move the button to say a switchboard or menu, then you can ask two question Open the spreadsheet y/n open the form y/n and take the appropriate...

you shoud'nt be concerned about the autonumber as this guarantees unique numbers not consectutive numbers. If you delete the contents of a table then compact the db, the autonumber will reset. Another thing you need to provide is error trapping. Whenever you access external data there is...

are you using a reference to the outlook object library, or using the DoCmd.SendObject method. If the former remember you need the correct Outlook Library referenced in Access. So you could have one DB running on a PC with Outlook 2000 and one with Outlook 2003. This will require a reference to...

I have code to check when the first user logs in. here are a number of functions to count the number of users logged in and to check which group they belong to Option Compare Database Option Explicit ' Routine to Obtain a users permission Group ' Count ReadWrite Groups Private Const...

there are a couple of techniques you could look at, one is the forms me.Dirty property. This is set to true if any field is changed, or you could do it your self by creating a onChange event for each data entry field where you would set a flag in code. The latter technique will allow you to...

use workgroup security, then you can assign read/write permissions to groups of users or individual users.

if you are using a query as your recordset, then that will be where the problem lies. In my experience it is usually the join type. Experiment with the different join types.

it sound as though you have not granted the correct permissions to the user. experiment, try giving the user full admin rights and see if that works, if so then the problem is a permissions problem only.

Columns may only have one font - this is a limitation of Access as it is not a word processor. Why would this need to be at table level? After all tables are for storing data, you would view the data through a form, query or report.

removing a table from the relationship window does not remove the relationship. So add all the tables back to relationship window. (hint right click in the relationship window and click add all tables). Are any tables connected by lines as these are your relationships. Right click the...