Search results

I cant seem to figure out how to make the update query work...Basically what I want it to do is When I query out records to see in form, even if I do nothing at all to any record, I want it to append those records to tblHistory and put current date in date field (in tblHistory) when I close...

Thank you SJMcAbney..I learn so much each time I come to this forum... So, how do I get it to put date on each record that appears in my form (datasheet view)? It only appears on first record and the empty record at bottom.

I know this is a simple question but I just cant seem to get it right. I have a form that is run by a query...the query filters out all records from the table that match the dayofweek I input..for instance, when form opens popup box asks what day? and I input Monday...all records with shipday...

Thanks, it worked!!!! Did not even know that option was available... I LOVE THIS FORUM!!! Thanks so much Noreene

I have a form that employees use to enter the minutes of each order that is being picked. The problem is some employees have found a way to use the back arrow key to look at previous records and sometimes changing the minutes...That causes the employee's minutes to be incorrect and therefore...

Many thanks to you...I will try this first thing tomorrow!!! Noreene

I have checked a few of the postings but havent found exactly what I needed. I have a table that has every employee and the hours worked per day for this year. My boss needs every employee's hours summed by w/e. All the info is there, I just dont know how to sum it by week ending..(almost 52...

Thanks for your help. Noreene

I have a query that pulls # of employee occurrences in a date range...right now in my criteria line under occdate I have: between date() and date()-180 (That pulls all occurrences for employee between today and 6 months ago) I think what I need the criteria line to say is: between [enter...

I want to thank all of you for your advice...I HAVE LEARNED A LOT !!!!! Noreene

Private Sub Position_Exit(Cancel As Integer) Dim EmployeeID, FirstName, LastName As String Dim strsqlnew As String EmployeeID = Me.EmployeeID FirstName = Me.FirstName LastName = Me.LastName strsqlnew = "INSERT INTO tblEmployeeStatus(employeeid, firstname, lastname)VALUES ('" & EmployeeID &...

Thanks Tim for your help...that makes sense..I am going to give it a try.. Noreene

Could someone please tell me why I cant get the 3rd option to appear when I do a combobox wizard? Thanks for your answer, Noreene

I am trying to format a report that shows everyone that has time off by date in each week. (This report will be printed each week.) I made a select query that has date and name. But, I want the report to show as follows: 09/20/04 09/21/04 Noreene Jim Jim I cant figure...

I have a form that I want to have combobox in form header that pulls from employeeinfo table. Has every current employee in it...Then I want a subform based on a query for the detail section. The query should pull every instance of the employee name from disciplinary table. So, ideally the...

Thanks to you, Uncle Gizmo!! That seems to be exactly what I need! Noreene

I am also having a problem with numbering. I know this is a simple question, but I cant hit upon the right answer. I have inherited a database that the employee id SHOULD HAVE BEEN an autonumber, but was not. Now, the table will not let me change to an autonumber (has many, many records and...

I have checked the forum for security posts and havent quite found what I am looking for...so, here is my question. I have a database that allows users to input info, supervisers to run queries and reports, etc. Works fine!!! But, the terminal was moved to another place that is out of the...

yes, in the table pane of the Access window...I felt like it couldnt be changed the same way as Excel and Word because there was no format option. Thanks Doc Man.

Someone asked if you could change the color of a table name....I couldnt find any way to do that....Is there a way? Thanks, NOreene