Search results

Thank you for your replies. I will take your advice and put more effort into consistency. You're right. In the future it will be much better if I am looking at something that's consistent in its form. This is just something that I'm using to learn Access. It's a nice challenge for me and I think...

Would I just need to add to the table that holds the rates of service? ID2 for another service on the list, with a corresponding rate? ID3 with another service with its rate? And so on?

Thank you for your replies. Yeah, you're right. It would make more sense like that.

OK, I figured out that I have to change the field names of the 3 fields (BillRate1sthour, BillRate2nd, and taxrate) to be the same as the ID fields in the tables holding the values that I want in the corresponding boxes. So I changed them to 1stHourRateID, HoursAfterRateID, TaxRateID. I changed...

Ok here's what I've been working on and asking questions about. Here's the latest. I thought I figured out the problem I was having. But I was wrong. ******************************************** TicketF- ticket form with ticketdetailF as a subform TicketF is connected to the TicketT table, the...

I've been looking into what's happening. And it looks like what's made this difficult is that the time (hours) entered are going into a subform of the ticket form. And the subform where all of the action is happening is a continuous form.

Update.... it does work upon opening the form. But when I type something into a different field, the value that I finally had populating into the combo box disappears. I guess I've got to keep on searching?

Thank you both for your replies. I've been working on this for hours since. And I was on the verge of replying to you both, explaining that I've tried everything but I'm not getting anywhere. It looks like the solution was to follow recommendation #1 from Arnelgp, and then add the following to...

Thank you for your reply. Yes, the form that the combo box is on is bound to a table. The combobox properties are set to: store the value entered into a field of the table that the form is set to "BillRate1stHour". The connection to the table holding the billing rate is through it's row source...

Hello. I'm in the process of learning access, and I've got a combo box's data source connected to field of a table. That field holds the value of the billing rate. So, to change the billing rate, just open that table and enter the new billing rate. From there the combo box will reflect the new...

OK, so the one table with 6 fields approach can be used without duplicate creating entries for dates per machine? For example, if I'm on machine 1, and I enter a description of my work into the DB. And then the 2nd shift comes in and there's another guy working on the same machine. When he's...

OK, thank you. I was just having a hard time wrapping my head around making this adjustment. But I think I can figure this one out. Thanks again.

That does seem like a much better approach. However, It looks like I would have to create the fields that you've mentioned. But ones for each machine, per date? I need to have a daily record kept.

Thank you for your advise.

It queries notes from work done on 35 different machines. One table per machine. There are 2 shifts. One field per shift, for notes. SELECT Minutesof1V18tbl.Dateof, Minutesof1V18tbl.NotesShift1, Minutesof1V18tbl.NotesShift2, Minutesof200V1FTtbl.Dateof, Minutesof200V1FTtbl.NotesShift1...

Hello. I have a simple query. It queries 3 fields from tables. And only 1 of the fields has criteria, which is Date(). The only problem is that it queries 35 tables. When I put the 35th in there, I cannot run the query. I've tried to change the field names to something smaller, to give Access...