Search results

Help, This is driving me mad. I am trying to connect to a database using User Level Security. I am setting the table name in code as below: NewTabName = "tblIcons" i have the following code so far: 'reattach table from new database Set tbl = db.CreateTableDef(NewTabName) tbl.Connect =...

Cheers Many Thanks. You're a star!

I need to be able to display the names of the querys and reports in my database. From here a user can then request to run the report they require. I know you can reference the database types in a query but cannot remember how. Can anyone remind me please. Thanks Arry :p

Just set the queris to delete after X days and informt the user of this when it is created. The dB Administrator can keep an eye on it! Unfortunately as per previous it ain't possible. Bummer!!

If they cannot change the data in the tables then i don't see any reason why not. It just means that capable access users have more freedom to extract the data they want.

okay thanks anyway.

i want the query in design view so the user can create it themselves. I cannot do that with a query can i. It is a new query with nothing in it until the user selects tables etc...

I have a database running with the application window hidden and would like to give users the option of creating querys based on the built in query wizard. The query when opened using a button on a form is not displayed on screen because the app is hidden. I need to somehpw set this to a pop...

yeah, i think that is going to be very tricky. Could you update the counter on the number of seconds passed. When the total is reached the counter would just start again. Wouldn't really be a progress indicator but would so that the DB was working??

yeah, i think that is going to be very tricky. Could you update the counter on the number of seconds passed. When the total is reached the counter would just start again. Wouldn't really be a progress indicator but would so that the DB was working??

Okay, Thanks for that. I think it may take a while to incorporate this but i will have a go. Thanks for your help.

Apologies. I am running access 97 and cannot open your attachment.

Apologies. I am running access 97 and cannot open your attachment.

I am running so complex code from a form button. While the code is running i would like to display another form which displays the work busy. I have included code from the button to Docmd. openform etc.. but the problem is that the form is not displayed fully. i e you get the outline but no...

I have a timeconsuming task that is intitiated at the click of a button by the user within my access 97 database. Is there any way of continuing to browse throught the database (forms etc)while the code is still running?? Any ideas! Thanks Arry

Convert your queries to VBA code. This will speed up any queries you have to run ten fold!:)

Thanks for your help. It seems to be working okay now. Thanks Arry:)

I am running code in Access 97 as follows. SQL = "INSERT INTO [Tbl_Adjustments_Data] ( [Invoice Number], [Invoice Period], Type, Type2, Comments, [Date From/For], [Charge (£)] )" & _ " SELECT Left([F1],10) AS [Invoice Name], Right([F1],4) AS [Invoice Period], TempAdjustment.F2...

Thanks Guys thats great.

In VBA i need to run code to check to see if a table exists. If it does i am appending records to the table from my VBA sql, but if it doesn't i need to create the table. I have created the code to append or create new but i cannot find out how to "check" to see if the table exists. There must...