Search results

The field type of ParkingPass can be whatever you like; I decided it would be best to make it an Integer because when it comes to building queries and reports, you can use an expression to add "Parking Pass " to the integer, making it display like "Parking Pass 1". The main advantage of using...

You can use the guardian table with a junction table to display a many to many relationship. Also, you could add fields to the junction table to describe each relationship. The junction table might look something like this: GuardianID, Relation, StudentID 1, "Is Mother of", 1500 2, "Is...

Maybe if you add one field 'DateIn' you can use the presence, or absence of a value in that field to determine whether or not to allow a check-in or check-out You would use 'ExpectedBack' simply for informational purposes Also note the absence of spaces or special characters in table and field...

In IE 8, after following these steps, it seems to work correctly. Tools -> Internet Options -> Browsing History -> Settings Button - {Delete all files there} Close and reopen IE. Browse to this site. Sign-In I am correctly taken to my User CP page But why would it suddenly not work in Chrome...

I've noticed yeseterday and today, on both my computer at work and at home; When I log in to this site, I am usually taken to my User CP page automatically, but instead it redirects me to the login page again. Once there, If I click on "Access World Forums" in the upper left hand area, I am...

Actually, after thinking about it a bit. It's even simpler. You will have your main form with the search box and a button. On that form is a subform. The recordsource of the subform is something like this: SELECT Files.*, Boxes.ShelfNumber FROM Boxes INNER JOIN Files ON...

Hi jr365. First, welcome to the forum! It sounds as though you will need an ubound form with a textbox (where the user will enter the filename) and maybe a button to perform the search. By "perform the search", I mean the code on the button would insert the filename into a sql string. You...

If I remember correctly, that information is probably obtained from each student's registration form. So, if student a says they are related to student b, the school assumes this to be true. But, what if student b does not say they are related to student a? I think by building a junction table...

Okay, so to add to The_Doc_Man's advise. When you have your queries built, you can run them from your form two ways that I can think of: When the form is first opened: Run the queries against the entire table1 and peform any updates needed to the entire table2 You would use the OnOpen event of...

Here's the difference.

I see. So the data in table1 lives it's whole life there (in the same database). On form2, it's recordsource is table2 correct? Is form2 a single form or continuous form?

Ok. I understand a bit more now. Let's start from the beginning. How does the data get to you? .csv format, external database? What I'm getting at here is: The data must be coming from some place and it is constantly changing. The easiest way to do what you're saying is get in touch with the...

Agreed. If you receive the tblCal data on a regular basis, you can use a UNION query to transpose columns to rows. This might be your best bet. However, If you have to then edit or add-to the data in tblCal it becomes more complicated when you are using a UNION query. The UNION query would...

"hooking into an event" is programming jargon - sorry about that. It's just a figure of speech meaning "When this event happens I want this other stuff to happen too." In Access, when a table is opened, there is no way to make other things happen automatically. "you can't hook into the open...

Sorry, I guess I edited my post while you were already reading it... What are you ultimately trying to accomplish? What's the big picture?

Sounds like all the data updates are flowing one way, so to speak. If I understand correctly, anything that happens in Table1, you eventually want it to update to Table2 as well, but not the other way around. Is that accurate? I'm pretty sure you can't hook into the open event of a table...

One question. Will you ever need to input data into tblCal?

Even though you have set the form's allowedits and allowadditions properties to No, in addition to setting the Locked property of all the controls on the form to Yes? Try this: copy and paste this verbatim =DLookUp("[FirstOfrptColLbl]","qryColLbl","[rptPeriodMaster]= '" &...

I think this is what you're looking for http://www.lebans.com/callbackbrowser.htm

That's rediculous Microsoft! j/k :p