Search results

When it's time for me to go, I want to die just like my Grandpa did, in his sleep. Not screaming bloody murder like the other three guys in his car.

I have a simple database that opens with a main window displaying 5 buttons that can open 5 different forms. I have created 2 security groups -- one that allows full access and the other read only. When logged in as a Read Only user, there is one form that spits out a runtime 3011 error, could...

Thanks a lot Ken. That solved the problem. I really appreciate it.

Unfortunately, no I did not. Can't figure out why the one record is omitted. Were you able to run the program and see what I was talking about?

Let me know if you have any questions. Thanks.

That works perfect! Thanks a lot Ken.

tblStationData is the original table. Thanks again

Yes, 3 in the original table. Currently, I have only 2 in the temp table as I want all of the data from offset and elevation fields in the same field.

Hi Ken, I have been working with your code and think I'm getting close, but still not getting exactly what I need. For the sample table below: station * offset * elevation 49330 * -0.125 * 570.94 49330 * -0.03 * 573.78 49330 * 10.305 * 573.17 I get: station * data 49330 * -0.125 570.94 49330...

Ken, That is exactly what I'm looking for. My table has a third column, so if I can figure out how to add that to the mix, I'll be in business (very little coding experience here). Thanks a lot!

For the sample table below, Station Offset Slope A 3 21 A 5 19 A 7 14 B 1 8 B 1.5 6 B 3 5 B 7 2 Would it be possible to use a query (or any other way) to create a new table out that looks like this? A 3 21 5 19 7 14 B 1 8 1.5 6 3 5 7 2 In other words it alternates...

no, no cascading combos

I have a form that contains a field populated by a combo box. When I scroll back and look at previous records, the data in this field sometimes displays, sometimes does not. Looking at the source table, there is data in this field for every record, so the data is getting saved. However it...

Two old friends were just about to tee off at the first hole of their local golf course when a guy carrying a golf bag called out to them, "Do you mind if I join you? My partner didn't turn up." "Sure," they said, "You're welcome." So they started playing and enjoyed the game and the...

Thanks. As you can tell, I'm not a programmer at all, so if you can bare with me... What I've got is a button on the form. When clicked now, it actually opens the query window. The query results are exactly what I need. But, in a perfect world, when the user would click the button, the query...

After the form is already open, our users want to sort on a text field that is a combination of numbers and text. They want the sort in descending order with 7L-1500A above 7L-856, etc. I have created a query with a rather complex expression that will accomplish the sort correctly. I have a...

Does anyone know of a good reference that lists and describes all of the available functions (len, right, left, val, etc.). I'm not fond of wandering through Access 2002 Help.

That doesn't seem to be the problem. However, I think I have narrowed it a bit. I compared the record that I was attempting to duplicate with the record that was pasted into the 'Paste Errors' table. All fields pasted successfully except 3. They were all Date/Time fields. Unfortunately, the...

Unfortunately that code generates the same error.

I compared the code under both NT and XP and it was identical: Private Sub cmdDuplicate2_Click() On Error GoTo Err_cmdDuplicate2_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70 DoCmd.DoMenuItem acFormBar...