Search results

I have to have separate tables for each client because we input the data and send a file to the client and each client wants different fields. If all the fields were the same or somewhat similiar I would have them in one table. But thanks, I think I figured out a way around it.

I was wondering if someone could tell me an easy way to do what I'm trying to do. I have a table with orders in it. There are 2 fields in that table that I need counts for. Received date and exported date. I need to count how many orders we receive each day and how many we exported. But I...

That worked perfect Elana thanks, I was under the impression that you couldn't do that with the table that was set as the forms record source. Thanks again.

It still doesn't work. It's only counting the number of orders that have been entered since the form was opened. Which means if I open the form there are no records and I get the error "No current record" when I movelast. Maybe I'm not referencing everything I should be referencing I don't...

Ok, I figured out what's going on but I still need help to do what I need to do. It counts the records that have been entered since that database was opened but it's not counting any records that were previously entered. I need to count all the records in the table that is the record source...

I'm having a problem cloning the current record source of my form to check for records already entered. The code I'm using is Dim rst as dao.recordset set rst = me.recordsetclone I don't get any errors but I have a msgbox(rst.recordcount) which returns 0 even though there should be 3 records...

Thanks but I figured it out. When they tab out of the city text box I have code that sets the row source of the combo box with a SQL statement based off of the city text box. Now that I have that figured out does anyone know how to set the default value of a combo box to the an item in the...

I think the answer to this question is probably somewhere on this forum but not for exactly what I need. I have tables for each data-entry person. All the tables are basically the same. I want to be able to fill a combo box for a county based off of what the data-entry person typed as the...

I just added a second field so I could calculate the times with the datediff function. It gives me the minutes as a whole number is there any way i can get the exact number like how many minutes and seconds? I'm not very familiar with the datediff function.

I've tried researching this on the forum and on Help but I can't seem to find anything so if someone could help I would greatly appreciate it. I have a data-entry form that whenever someone opens/closes the form it puts a time/date stamp into another table along with the initials of who is...

This is the code I used Private Sub Combo88_AfterUpdate() s$ = "Are you sure" If MsgBox(s$, vbYesNo) = vbYes Then If Combo88 = "Rejected" Then Label91.Visible = True Text90.Visible = True Text90.SetFocus Exit Sub End...

I have a data-entry form and I want to put validation on all of my text boxes and combo boxes after the user enters the information and if it's wrong I want to set the focus back to the text box or combo box they just entered. I tried doing it in the lost focus but I can't put the focus back...

I have a query that sums up totals from a table then gives me a grand total for each customer. I want to have a form with a button and when the button is clicked run the query ReservesTtl and put the grand totals into table Reserves. I know how to open a table with code but when I use that...

I have a query with criteria. I want to use that query for the record source in my detail section but for some reason it does not work with criteria. If I take the criteria out the report runs fine. Can someone please help.