Search results

Solved the problem using a the following select statement in a stored procedure. See code below. SELECT CONVERT (nvarchar, DateSATURDAY, 101) AS DateSATURDAY FROM tblSATURDAYS WHERE (DateSATURDAY NOT IN (SELECT WEEKENDING FROM tblTIMESHEET WHERE (STAFFID = @uID))) GROUP BY DateSATURDAY HAVING...

Sorry Byte, So in the timesheet table, there's a weekending field. I have 100 users. When users login and select new timesheet, based on the staffid, how do I get the date dropdown to populate with unused dates, and if they choose existing timesheet, the date dropdown should get populated...

I have a table with staff id #s and names and a table with 5 dates. I have a dropdown which gets populated with the dates based on the staff id. For example, employee (EE) 157 lists 5 dates, because he hasn't used any dates yet. But, EE 160 lists 4, because she has used one. I hope this...

Can someone please look at the following code and explain why it's duplicating records in my MS Access database. THANX IN ADVANCE for your help!!!! ' FOR SAVING DATA TO THE DATABASE ******************************************...

I agree with Rural Guy. With the autonumber field, if someone creates a record then deletes it, it will throw off the count.

Just create the button....then with the wizard, choose "Record Operations", then choose "Undo Record". Keep in mind, this button only applies to the current record. Like Steve said, once you or your users advance to the next record or close the form, the record is automatically saved. Hope...

CONGRATULATIONS BOB!!! Thanks for all your help over the last couple of years -- even when you didn't know you were helping!!! Because of you and PBaldy, I am committing to helping more folks on this forum. Very well-deserved! Thanks again!!! YOU ARE THE MAN!!!

Melia, go to report design view and check open the properties window. Check the format of the date field. The only other thing I could suggest is to widen the control. With the transaction total, I would suggest running a report that gives the total and one that doesn't then doing some...

Keke, why not just use a combo box instead...where the user could choose either male or female. Much easier. If you already have records, just do an update query.

I figured that part out already...thanks.

Joepele, like Rabbie said, do an append query, using your original table as the source. Append the records to a new table without your 'autonumber field'. Remember to put the 'LastName' field to the left of the 'FirstName' field and sort both ascending. After you have appended the records...

Side note duly noted. Solution: I just created another table called "User Trail" and used it as the source for a subform. Then added code to update the two fields in the subform...works fine. Thanks for the help guys...

Bob, I don't update any info, just advance to the next record. When I come back, the fields have been populated. Am I doing something wrong? Also, another question. In a query, how can I write an expression that returns records with an expiration date of 2 years to the day?? In other...

Bob, thanks for the quick response, but the Before_Update updates those fields regardless of if I change any of the data or not. I only want the values to change if the data is modified in any way.

Access 2007 -- LOVE IT OR HATE IT??? I have a macro: SetValue Item: User Expression: CurrentUser SetValue Item: LastUpdated Expression: Now() The macro is called "Last Modified", and I have it set to the After_Update property. I have even tried the following: Private Sub Form_AfterUpdate()...

Sierra, I too have tried to design a report very similar. First, go to the design of your subreport and choose 'page setup', then select the 'columns' tab. You can set the parameters there. But here's where the problem comes for me. If I choose the 'Across then down' option, I'll get the 3...

Jukus, check your column settings. I was having the same problem, and noticed under my column settings, the width was set the 6.5". I just clicked the "Same as Detail" box, and my report was fine.

Try turning off 'Name Autocorrect(?)' under options.

Switchboard Page Titles In case anyone is still trying to figure this out, just add a textbox (I called mine lblPageTitle) to your form, and include the following code. Private Sub Form_Current() ' Update the caption and fill in the list of options. Me.Caption = Nz(Me![ItemText], "")...

OK DCrake, Think I've got it now!!! What I did was create a query called qryMatches. Included the fields name, id, dob, homestname. In the name field criteria I used "Like ([forms]![new entry].[txtFirstName]&"*") & " " ([forms]![new entry].[txtLastName]&"*"). I use this query as the record...