Search results

Sorry, I should've been a bit clearer. Users will not need to modify data, only analyze it. I don't want to deal with what analyses they may want to do, so I want to just furnish them with fresh copies of all the pertinent tables periodically, then they can massage data to their heart's content.

Hi, I have several users who want to link their User.mdb to my BE.mdb backends. Seems like a reasonable request. However, I am reluctant to allow this because it severely compromises my ability to do maintenance work: For example, if a user is linked to the BE.mdb, I can't repair/compact it, and...

I am truly stumped. I have a query that sometimes takes less than 1 second to run, and sometimes takes close to 5 minutes. I am making NO changes to the query. I first thought it was a network issue, so I moved the whole db, both front-end and back-end, offline. No change. So I thought maybe it...

I have 4 nested forms: DataEntryMaster DataEntryMainSub (subform on DataEntryMaster) DataEntrySub2 (subform on DataEntryMainSub) DataEntrySub3(subform on DataEntrySub2) In the AfterUpdate even of DataEntrySub2, I have code that checks to make sure the field on DataEntrySub3 (it has only one...

How would I do this for all the tables in my db???? Wouldn't I have to do a separate query for each table? Plus, I'd still have to specify the field,wouldn't I?

Hi, My company has renamed a product. I want to find all the records in all the tables in my database that might have the old name, and replace with the new name. What's the easiest way to do this? I don't really want to have to manually open each table and do a find. I can write code to go...

I've yet to receive any responses to my previous post so am just rattling the cage. Is it just not possible to enforce referential integrity this way? Do I have to violate normalization rules to do it?:(

I have attached a picture of the relationship I want. In table Repairs, there is no primary key: Each barcode can have many entries with the same or different refdes. Table FailureBarCodes defines additional information about the barcode. Here, barcode is the primary key, and we find out what...

Table Repairs has fields: FailureBarCode RefDes Table FailureBarCodes has fields: FailureBarCode (Primary Key) ProductItemNo AssyItemNo Table BOMs has fields: AssyItemNo RefDes (The two fields combined are the primary Key) I want referential integrity so that a refdes can't be entered in...

I have a report created from a crosstab query (via very useful code in Chapter 9 of Access 2002 Desktop Developer's Handbook by Litwin, Getz, Gunderloy). However, the report extends horizontally across multiple pages, and I need the left-most "columns" in the report to show up on each page. The...

Hi, There is a .txt file that I regularly need to import into an Access database using the Access transfertext function. This same .txt file is a shared file that can be opened by others. I am having an intermittent problem importing the file into Access: sometimes I get Error #3051 (already...

I have an unbound form with some unbound controls where the control source is set to something like This has worked fine for a long time, until today, when I tried to implement some conditional formatting on these controls. Now, half of them are returning "#Name?" instead of a value. Even...

Thanks! I feel sorta stupid that I didn't know that... seems like a fairly important thing to know!

Okay, this has got me freaked out, as I didn't think this could happen: I expect Sub FirstSub to print "27", but it prints "32". How can this be??? I thought a Sub would only perform a task, NOT return a value? All the years I have been programming, I have assumed that sending a value to a Sub...

Quite often I have the need to do something like the following, to refresh data in a table: currentdb.execute "delete * from MyTable",dbfailonerror docmd.transfertext acimportdelim "MyImportSpec","MyTable","MyTextFile",true I would very much like to enclose these two lines within a...

Thanks for the advice. The direction I"m heading right now is to force users back to the main menu (as you suggested) instead of all the way out of the db. I have code that will "un-dirty" any currently dirty records prior to running the updates. I was hoping that maybe if I did that, then...

Hi, Even though I've been developing access apps for years, I still feel like I need a book called "record locking for dummies", so please excuse if this sounds like a dumb question: I have a db that I need to run a bunch of auto-updates on, multiple times per day. That same db is in use pretty...

Thanks, already did that. Running the query from within the code, it says there are 183 records affected, but the updates don't show up in the table. Then if I run the query again, outside of the code, it says 183 records affected and the updates DO show up in the table.:mad:

When I run the code listed below, I get no error messages and everything seems to work correctly, but the records I expect to be updated by query CurWIP_Update3 do NOT get updated. If I turn CurWIP_Update3 into a select query, it looks as if there will be 90-some records that get updated. But...

I am trying to use docmd.findrecord on a form, with the search direction option set to acSearchAll. But this option does not seem to work. Here's what I'm doing: NounLookup is, of course a user-entered value on my form. I enter a value and then click a button to run this code. It works fine...