Search results

In Access 2010, Win 7. I have 2 tables. Very simple. 1) tblEmployee Fields: EmployeeID (KEY) , FirstName, LastName, Site, UnitNbr. That's stagnant data, as it rarely changes. But there maybe several hundred employees. The only thing that might change is the "Site" and "UnitNbr". 2)...

I think there is much better ways of doing Bible Study than in Access. Such as in Logos and others where every WORD is digitized and searchable. I think that's far more useful than verses or phrase. And many good programs do that very cost effective. In fact the apps are free for many phone...

In my "Log Book" table I'd like to be able to enter the "Employee ID" and have Access populate the fields "Unit#" and "Site" which are very consistent and rarely change. Therefore I have those 2 data items in the "Employee" table. I can make a combo box or list box and click on the...

Well that improved things so it calculates on the tap. But not until the last of 4 tabs. So yes thanks, that is an improvement. Don't need to reach for the mouse anymore. However won't Access calculate "live" like Excel does? I have 4 fields in a row and in tab order. The first 2 have a...

I'm obviously missing something Private Sub Driving_Change() Me.Requery End Sub This comes up with a Yellow because it doesn't like this.

One concept that I just can't seem to get my head around and make work. I have a 2 table data base. Simple. 1) Employee c/w a UnitNBR and a "Site" field. 2) Daily Work Log for each employee. I have an "employee ID" field, who is assigned a piece of equipment "Unit Nbr" and resides at...

I don't know of a Bible in Access, but Logos is my favorite software Bible resource center. ;)

I have a form where I enter 4 numeric numbers which HAVE TO 1) total 24 (hrs in a day) and 2) - 2 of the 4 can't exceed 14. These numbers are not stored in the data base. They are just there to visually indicate to the data entry person that the numbers are correct and without error and do it...

"If you want to open your form showing all records but got to a new record you could use the DoCmd.GoToRecord method in the Form's On Load event to Go To a New Record. " I'm missing some syntax here?

While we're chatting. How can I force my form to open in a "New Record" window instead of the first record in the Table? I hope my "Reputation" check recorded, I can't see where it did. :-(

As I enter Data into the "Form" I'd like it to give me the last date entered in the "Date" field. this would save data entry time over having to stop and select the "Date Picker" with the mouse. (although I lone the date picker) it is slow. Then I could just keep tabbing over that field greatly...

Thank you so much. This form seems so impersonal to just say thanks to someone you cant shake hands with. :-( Thank a ton!!!!

On my form my Tab stops at a "New Record" button. After the "Enter key" can I make the cursor go to the first field in the form?

Don't know what I did but it works fine. thank you so much.

Thank you, oh thank you. I'm 65+ and trying to develop a application to obtain an office job so I don't have to drive truck anymore. My bones ack too much for that! :mad: I've go the following working (with your help) - sort of. Private Sub LBErrors_Click() If Me.LBErrors.Caption =...

Doesn't like the red print?

Private Sub Command86_Click() Private Sub cmdYourButton_Click() If Me.cmdYourButton.Caption = "Show Errors" Then Me.Filter = "[YourYesNoField] = True" Me.FilterOn = True Me.cmdYourButton.Caption = "Show All" Else Me.FilterOn = False...

I'm sure your right on, and I will try it. Coding / VBA scares me. I'm an Old Cowboy. :rolleyes: I don't ever need them to find the records that are correct or "checked" TRUE. Just the erroneous or FALSE ones.

I'm an OLD RuralGuy and VBA is still over my head. :-( I was hoping there was a simple way to do this without 2 forms. I could build a second form to the QUERY, I guess. Thanks anyhow.

Ya sorry, I was wrong. It is bound. I'm looking at the filter options. But. I want to publish in a stand alone program and don't want employees trying to learn how to filter. That's why I thought a simple button would be idiot proof. :-)