Search results

What do you mean by a graph in a graph?

If a user goes direclty to the MDB file and try to open it they will receive an error stating the do not have the nessary permissions.

Not sure if you can change a linked tables path in an MDE but if you can look into the TableDef object.

Can you post your field and table names? Something like below should work Delete * from PermTable Where DrawingID In (Select DrawingID from TempTable)

Instead of using the reports record source property to view the records try useing the reports recordset property to retrieve the data from an open recordset. You can use the Load event to open the recordset and set the reports recordset property to the recordset you just opened. I believe this...

The FilterOn property should do the trick. Are you using query parameters not form filters, maybe?

I would go with option 2. You could create a query to link the two tables together to display the data.

I have done something like this before. What I did was use the FileSystemObject to first see if the path existed (read access), then see if I could create a text file, and then check to see if I could write to and delete the text file.

Why not just export the query to a spreadsheet?

You could use an update query but why would you want to store this if you can use the above expression to get the same result? Seems like a waste of space.

No problem glad I could help

try Docmd.echo false close form open form docmd.echo true

Yeah I saw that but thanks. It is a challange explaining to the project group why they got ride of ULS. I agrue that honestly since Access is a file server db your data is not truely safe anyways becuase the users need access to the file. So if someone knows what they are doing its only a matter...

Has anyone seen any good links to explain why Microsoft discontinued User Level Security in Access 2007? If so can you post the links. There is a debate at my work and I want to get all the infomation possible. It is my understanding that the beefed up the encryption on the standard password so...

So basically when the record is created you want to populate the date? If so go into the table design view and in the date fields default value Put either =Date() or =Now()

You could just use the left function to test the name if Left(FileName,6)="x_Choc" then ..... Else if Left(fileName,7)"x_Cocoa" then .... End if

Thats a good one!

I would take this as a lesson and make sure you back up your db before working on design changes.

Look at the mail merge with Word feature in Access.

what are the fileds names and the table name?