Search results for query: *

Triacona, you can check out the faq's faq702-5248 is how to calculate a running total. Other than this I am unable to help. I have little experience with this currently. I will be interested to see your solution. It may be better if you post this question in a seperate post. Have fun...

Triacona, Glad to hear your program enters dates correctly!! Creating the next record only added a record to the current employee. It does not advance to the next employee record. It sound like you want to use the TimeInOut button to do this. I would encourage you to use an employee...

Triacona, I have a solution for you. Looking at your code to punch out for lunch this code cannot run because it looks to compare a date that is null 'your code from above If IsNull(Me.TimeOutLunch) And Me.TimeOutLunch > Me.TimeInMorning Then 'checks if TimeOutLunch IsNull and TimeOutLunch is...

Triacona, I wanted to write my code as close to yours as possible, but I'm having some trouble with that. I did the auto forms like you did. Issue: I usually make my own forms and link them together. I am unable to utilize "me." to reference the time fields nested in the subform. I ran...

Triacona, what do you use as a record source for your dates subform? Is it one form or does it have a subform for the Times table? From your code it looks like your subform's record source would be from a query pulling data from both the Date and Times tables. Learnin', Growin' and Failing...

Triacona, At this time, how do you select the employee on the employee form? Do you use the built in record selectors at the bottom of the form window or have you built your own buttons to navigate to an employee's data? I'm building the table structure and forms as you have described them...

Triacona, My Appologies!!! You need to have EmployeeID as the primary key in the table [Employees] linking to the field EmployeeID in the table [Dates] BUT it cannot be a primary key in both tables. You need another unique identifier in the table [Dates] to link to the table [Times]. Again...

Triacona, Happy Learning. This is a good exercise for you to start understanding relational data. I KNOW the frustration. You'll get good advice at tek-tips!! In response to "Please help, very confused at the moment..." Let's start with your tables. [Employees], [Dates], [Times]. It is...

best regards, Triacona I know you've moved onto 3 tables now, but the error "Quote (Error Message): This Recordset is not updateable" is usually the query property setting. Check your query TimeRecording by opening in design mode, right click, open properties look at "Recordset Type" & set to...

Smalty, I surmize you link the 2 tables together to utilize the subform ability, are you linking on an order number? Is that number unique? Would it make sense to utilize that number as the DNoteNo? if your OrderNumber = 00005 then create a concatenated version in an AfterUpdate event when...

Thanks dhookom. That is how I've applied it. Now in actual use it returns a primary key. I started to play with it more to see how it worked. I thought maybe it's inconsitancy was something I was doing wrong. Learnin', Growin' and Failing Forward

I appreciate everyone's input. I am learning on the job doing what I can; reading as much as I can about Data systems, Access and SQL. As far as "real" table record order I surmised that sort order and any user manipulation were visual to the operator and not "real" in the actual data system...

MajP and everyone the code was edited to use a static part number while troubleshooting. Originally code is for a text box input to be used as criteria. The parenthesis closes the function and orginal post is missing the comment out ' apostrophe before the inclusion of the text box input. My...

As I understand Dlookup function is to return the 1st record that matches the lookup criteria when multiple records match the criteria. for me it returns the 2nd or 3rd record matching the criteria and not the first record. To trouble shoot the situation I've sorted the table by date...

Thanks for responding TheAceMan1. From what I've read that's its job. It returns only the first record that matches the criteria. If this table were to hold mutliple records with the same criteria would it then be subject to the way the table has been sorted as apposed to when the record...

Christophercubitt, did you get the dlookup working and is the answer in this thread that solved your issue? Second I was unclear on what the original problem was. Was the look up returning the first record that matched your criteria (indicating there are several records that would match), or...

It is good to learn how to use multiple criteria for filters and parameters. Another way around this specific issue would be to set up a primary key or a unique identifier for each person in the table. Then use the combo box to list the 3 fields: [ID], [LastName], [FirstName]. Set up the combo...