Search results

I have a query based on 2 tables. Table A has loadDates. Table B has loadDateChanges(every time a loadDate changes in Table A, Table B generates a new record traclomg the change). I have a yes/no field in table B called "update" that automatically updates every night all records that are...

Thank you so much, both of you! It works now. I have been working with Access a while, but I steel need to learn so much. I will try to remember correct naming standards. It's gotten me in trouble before. I wish I could change them all that I did in the huge db that I already have. Thanks...

OK. I changed the name of my form and my query and used this expression and it still won't work. I get #Name? DLookUp("[STEEL]","Q_PurchExport","[LSC]= '" & Forms!F_MainEntry!LSC & "'") Any other suggestions?? I'm going home now and will try again Monday. Thank You!

Thank you. I actually copied what you wrote and pasted it and it still doesn't work. LSC is a text field. Could it have something to do with my query? The field STEEL is actually made from an expression.

I am trying to view information from a query field on a form that is bound by another query so I am trying to use DLookUp. The form with the field is F-MainEntry. The query that is not bound to the form is Q-PURCHEXPORT2 and the field is STEEL. My DLookUp looks like this and is not working...

Thank you! I will try these suggestions. It sounds like I can make it work.

I was wondering if anyone knew where I could get some help with linking SQL tables with Access. We have a program in SQL that I know very little about but there are is a lot of information in those tables that I could use in my Access db. Is there a good book or website with this information?

I will try these things. Thank you very much! Michele

Woo hoo! This is pretty cool! Thanks A LOT! So I guess now I have a parent, child, grandchild relationship??? :)

a little confused still This looks like it will do exactly what I need! But I'm a little confused. LoadDate is currently being entered into the 1st table. Will I need to have it entered now in the 2nd table instead of the 1st or in addition. Also, I'm not real good in VBA and I wrote your...

I have a field called LoadDate that changes very often. I want to track every time this changes. I want to know each date it changes and what the new date was, also knowing all the previous date changes. I thought about making a new table to track these changes. Could I get this new table...

Do you mean setting up the field with a mask at the table?

I have made a query that one of my criteria is a date field. When I run my query that criteria doesn't work right. If I put "Is Not Null" it gets all of them, but if I put a specific date as the criteria or Now() then it pulls up nothing when I know that date is there. That field's date is...

I have setup user level security on my database and now I want to use that same workgroup to secure some other db's. I am not totally sure how to do this. This is what I have done so far: 1) Set up a shortcut on my desktop (will do this on everyone's when it works) targeting the workgroup I...

I am totally not insulted at all! In fact, I didn't know that and it makes perfect sense since I tried it another way with only one subform and am not having that problem anymore. I am only a senior member because of the length of time that I have been a member. I am only a part time Access...

I have a form that has 3 subforms. Each subform is invisible until you select BLDG, CNPY, or CRWH from the textPLMNTYPE field. The field that links the form and subforms is the PLMNO field. I am having a problem with the PLMNO changing in the main and subform depending on what is chosen in...

I am trying write some code to print some reports, but only those that have data in them. I have used DLookup before but that doesn't seem to work this time. I have also been trying to use the On no data event on my report. What code would I write in that ?

Replication? I hadn't read much about Replication until today. It seems there are some conflicting ideas on it. And I'm a little confused about it. I already have a backend (sits on the server) and a frontend (sits on each users desktop - but is copied from the network each time someone...

OK here are the messages I get and in this order: 1) The document JTTables.mdb caused a serious error the last time it was opened. Would you like to continue opening it? 2) The database JTTables.mdb needs to be repaired or isn't a database file. You or another user may have unexpectedly...

All of a sudden today I started getting Microsoft errors on my database. Only entry was going on, all day long and then all of a sudden errors. My tables and front end are separated. But my tables are in an unrecognized database now. Everytime I try to compact and repair I get the Microsoft...