Search results

Thanks all for your suggestions. The funny thing is: The table shows up in the order records were added. But the forms sorts by employee. Each employee has a months worth of records and that's how the "Next Record" arrow scrolls through the table records. I'm good to go thanks all.

So does Access arbitrarily decide which field it's going to sort by if left to it's own recognisance? Or have I got a setting telling the form in what order to display the "Next Record" goto?

Order is blank Order by on Load is - YES Changing that to NO, doesn't help. Still stuck

I have a table with about 290 record. When I'm in the "Form View" and click the "Next Record" arrow it scrolls by order of Employee instead of the primary key "Record Number". Why is that?

AH ha - I thought the software had to match the PC "bit". You cleared up my confusion. Thank you!

I'm on the verge of updating my PC tower. I hope to build some runtime apps for sale. I'm using Access ver 10. Is their a preference to either the 32 bit or 64 bit computer.

Is their a sister forum in this format for Excel users?

I think Dick and I are on a different page. I was trying to have the specific picture of the employee tied to his record. Sorry for not being clear.

That's the same basic question I asked somewhere else and didn't get a clear answer. How do I ask for a file location? If I can hi-jack this blog. :-)

Hmm thanks for that food for thought. I thought it best to use the PK to query other data or lookup fields. My semi-retired brain doesn't work like it use to. I'll have to think this through. Thanks very much!

Oh gottcha, I understand that issue. I thought there might be something ticking in the wings that could cause a melt down :-)

So I need to download either AccessRuntime.exe of AccessRuntime_x64.exe on thee computer I'm installing my "Published" application. Have I got that straight?

I can "Save and Publish" an ACCDE file. So that must be the full blown version eh? Isn't that all I need to develop something I can place locked down version in some of our off site offices? Thanks for your detailed response.

Is there 2 levels of Access 2010? What is Client? How is it different? How do I know what I have?

Why? What's the purpose of storing this value? Certainly not a viable candidate value for Primary Key; The books I've read suggest that for a primary key. When you look at it, it immediately means something. Whereas a number, auto or not don't mean anything to anybody except the computer...

I have a simple data base with 2 tables. One table is the pertinent Employee data. That includes a EmployeeID that I contrived myself with the first 4 letters of the FIRST NAME and the first 3 letters of the LAST NAME. I manually figured that out. Because I was new at this project. But I...

What do you mean about the "Coded Tags". Thanks for the heads up[ about what "Me" refers to. I guess I should buy a book on VBA for dummies :-) I'm going to try your advice now, but thanks ahead of time for your help!!

Ah ha - simple so simple, me too LOL. Thanks

I'm missing something. When I drop a field into a form I'd like to take the Lable Box and put in into the Page Header section and leave the data field or control box in the detail field. Sometimes I have available "Remove Layout" function to split the 2 so I can manipulate them around. What...

Or what about these add on's like "Opengate" advertised on this web site?