Search results

Thanks for the reply. I'd actually tried that, but my problem is that I can't figure out whether it's the form or subform that's triggering the error. I've tried tying the command to a number of different events to no avail. I was hoping there was a structural away around it rather than...

I have a form that contains 3 subforms. Whenever I add or change a record in the subform and then close the main form, move to another record in the main form, or even just click into a field on the main form I get a Write Conflict error (see attached image). Funny thing is that although it...

More Info I've been investigating this further and hopefully this new information may help: The database is split as a frontend/backend application. The problem is somewhere between the backend table and the linked table in the frontend, as the field properties are working on the backend...

I have a rather large table and associated query. I recently added a number of fields to both. Although it has worked fine in the past, the properties of the new fields are not being inherited by the query and any of the subsequent forms. I've tried making a new query and pasting the SQL...

After a little more experimenting, I've solved the problem. For those interested: The poor performance was due to network delay. If I wait a long long long long time and ignore the [Not Responding] warning, it eventually does respond. If I save the backend locally to a totally different...

I have a split database with the backend on a network. Everything's been working great until recently. All of a sudden the performance is quite slow plus I can't edit many objects on the frontend, and those that I can get into design mode, cause the database to lock up when I try to save...

Thanks Smed. I'll give that a try too.

Thanks Pat. That worked. Funny that they have 2 commands to do the same thing.

Drevlin...thanks for you input. Unfortunately the File Open dialog doesn't let the user create a new file name. It will only let them select and already existing file name. I need to allow them to do the former. ghudson...thanks, I'll try that suggestion.

It looks like some other developers have noticed this, but I've not seen a solution posted. My code: DoCmd.OutputTo acOutputQuery, strQuery, acFormatXLS, strFile Works like it's supposed to, creating a spreadsheet from the SQL statement in strQuery and saving it as the strFile file and path...

I found the answer to why the SaveAs doesn't work. For those interested, see this article . So can anyone suggest how to do what I'm trying?

I'm having trouble with the Save As FileDialog type. My code: Dim fd As FileDialog Set fd = Application.FileDialog(msoFileDialogSaveAs) Returns an <Object does not support this action> error. Funny thing is that this works fine: Dim fd As FileDialog Set fd =...

Perfect! I knew it had to be something totally simple. Thanks!

I have a form with multiple pages. I have set it to show only certain pages as appropriate based on what the user has entered. (I've done so to simplify things for the users). When the user opens the form, changes records, or changes the appropriate data, 6 pages are hidden or shown...

I'm trying to filter a graph in a report by a field in a form. When I add the field name [Forms]![FormName]![FieldName] to the criteria row in the underlying query, I get an error that Access doesn't recognize the field name. Any ideas?

Can anyone tell me how to round down (in this case to 1 decimal place). I need something like the rounddown function in excel.

Awesome! Great idea Rich. That will do the trick exactly. Thanks a bunch.:D

Thanks Rich. That makes sense. I do keep an unsecured MDB on my system, but I have to MDE it after I install because I need to make a code change specific for each system when I install. (I won't get into a long story about why that is...I just couldn't make the code 100% generic. Just...

I have a split database with frontend user-level security and two user groups: Full and Admin (and of course the default Users group). I've removed all permissions from the Users group and given the appropriate permissions to the Full and Admin groups. I'm having something strange happen with...

Yep. They always manage to surprize you. :p