Search results

That should work. If you do a query by SWO#, for each SWO# you will retrieve multiple NCs, which I imagine is what you want. I would recommend giving each NC a unqiue key so that, if you need to, you can use it to differentiate between them. Otherwise, your setup looks OK to me (for...

I honestly don't know. That's just the way it displays. You could try dd/mm/yyyy hh:mm AMPM.

Is that typical of Access? Is there a way to copy the underlying value? I admit I have more experience copying and pasting data in Excel, where it copies the underlying value (or formula) rather than the displayed value unless specifically told to do otherwise.

By doing the criteria as a Between rather than an = I'm working around the problem. It has, of course, opened up a whole other set of problems but fortunately those are just due to the structure of the database and, while annoying, are neither strange nor entirely unexpected. I'm still curious...

That helps. It confirms my theory and explains what's going on. Thanks

I still don't know why this query doesn't work. However, I have discovered that while setting the criteria to = doesn't work, setting at at <, >, <> or Between all work just fine. Furthermore, if I set the criteria as ">#7/3/2008 7:51:0#", the query returns results including 7/3/2008 7:51AM...

Is there any way the data I'm copying and pasting from the cell is somehow different from the data that is actually in the cell. To use an example "When is 1 not 1? When 1 is really 0.998."

Unfortunately, no. Sensitive data and all that.

Typing it directly, it would be July 3, 2008, 7:51 AM

OK, forgetting about the demended spiderweb of Joins for the moment. Let's take this query: SELECT Batch.datCreated FROM Batch WHERE (((Batch.datCreated)=#7/3/2008 7:51:0#)); How is possisble that I can I write the above query, copying the date/time criteria value directly from a row...

:) Like I said, I inherited that thing. I can only assume that the guy who designed it knew what he intended. I know that it works for what he designed it to do at least, but just deciphering it has been a nightmare. Anyway, ugly as it works, I know the joins work. At least, they work when I...

Here's the mess that is the SQL UPDATE Article INNER JOIN (BatchName INNER JOIN (MeasType INNER JOIN (((((Plant INNER JOIN Mach ON Plant.keyPlant = Mach.keyPlant) INNER JOIN Batch ON Mach.keyMach = Batch.keyMach) INNER JOIN Meas ON Batch.keyBatch = Meas.keyBatch) INNER JOIN AllMeas ON...

Hello all, I've run into an odd problem and I wondered if anyone here might have some input. I "inherited" a database from a fellow who retired and I'm trying to make some modifications to it. I made a copy of the database, so I can mess around with it without worring about changing the raw...

Thanks, I'll try that.

Good to know. Thank you. Is there a way to run the VBA code when the record is committed, instead of running it after update? Thanks, I know. It's just an "experimental table" that I use to play around with the structure of the code. I'll use something different in the real version.

Hello all, I'm trying to write a bit of VBA code to check a check-box when a certain value to selected in a dropdown box. I've built it as an IF/THEN statement to run an SQL Update query. Here's the code: Private Sub text0_AfterUpdate() On Error GoTo Err_text0_AfterUpdate Dim frm As...

Nevermind, I got it. Thanks a bunch for the help.

Thanks. Unfortunately, I'm still not getting it to work. Based on that resource I've changed the code to look like this: Private Sub Department_AfterUpdate() Dim ctlCombo As Control ' Return Control object pointing to a combo box. Set ctlCombo =...

Hello, I'm relatively new to VBA programming. I'm trying to do somethingthing relatively simple, that isn't working and I have no idea why. I've got a form with a subform. Within the subform, I've got two combo boxes: Department and Training. What I want it to do is this: I select a...

That worked! Thank you lagbolt.