Search results for query: *

I am a fool...(and some more sleep at night would help too) It works great

I have found a temporary work-around that should work for now... I have set the grouping for my [Date] field to Group On Week with an interval of 1. I then made sure that my report was using 'system settings' for the date grouping property. I then simply change the time zone of the server to...

Thanks for your help, but it is still not working for me. I have set the Group On value to 'Each Value' and the Interval to 1. When I enter your expression... DateAdd("d",-Weekday([Date]-1)+2,[Date]-1) It returns a 'syntax error extra )' message. I have tried this DateAdd expression a...

If I change the interval number, the last digit in the error message simply changes to reflect that number. If I change to sort by 'Day' instead of 'week' the 7 simply goes away and there is only one \ and one number (the interval number) reflected in the string. I'm still strugging to see how...

Thnaks so much for your post...(I realize now that I can write expressions in that sorting and grouping dialog box)...though I still don't have the syntax correct. When I use your expression in the grouping box...It returns... Syntax error in query expression...

I have read through many posts on this forum that are similar to my problem. However, it is now clear to me that I don't understand Access reporting as I cannot figure out a solution. I have built a report using the wizard in Access. I have three criteria in my report...Date, MachineID...

I usually label my controls and fields with prefixes (ie. lbl,txt,cmd) so I didn't even think of that. But I see what you are getting at. I will go back and check. I have a number of subforms and tabs on this form so I'll bet your suspicion is correct. Thanks

Bingo!! Works great. I also found that the Now() statement works correctly. I have used the Date statement in the past and have not had to use the VBA prefix. Do you know why it was behaving this way for me? Could I be missing a reference? Thanks again.

I have a table in Access that records the backup status of various servers. The table is updated daily. I want to create a summary form that will show the past 7 days as column headings and each server as row headings. The status (successful/unsuccessful) will then be displayed in the data of...

Thanks for the reply. I left this problem for a bit to work on some other stuff and had acctually just fixed it when you replied. I was previously getting an error that stated something like...("Cannot access the properties of a control that does not have the focus") However, it must...

I have written some code in the BeforeUpdate event of a form that will search all of the control boxes on the form and record any changes to those controls to another table (tblChanges) along with other relevant info. My problem is that when I use the standard record navigation buttons (which...

Don't know about the network problem...but that wizard is activated by the toggle button with the magic wand and the stars located on the toolbox tool bar where you get your combo boxes from (view/toolbox) if not already visible. eric

OK...you have a couple of options. I think the basic problem is that Request# is the PK of BOTH tables. It is best when forming relationship if you have a Primary Table in the relationship. make another field in table two and call it Key (or anything you want) and set it as your PK and make...

sorry...your right... Have you tried to 'unload' it. I am fairly sure there is a .unload statement that removes it from memory. eric

try calling the method instead of the action... DoCmd.Close [objecttype, objectname], [save] objecttype is an intrinsic constant (probally acForm for you) the default constant acSavePrompt is initiated if the the save argument is left blank but you could also use acSaveNo or acSaveYes...

Are the two tables joined in any way? Also, I assume from your subject that entry from page one is not being stored... but did you check your table and make sure that it is not storing it and then displaying a new record that is show when returning to page one? (obviously this would still be a...

I have written some code in the BeforeUpdate event of a form that will search all of the control boxes on the form and record any changes to those controls to another table (tblChanges) along with other relevant info. My problem is that when I use the standard record navigation buttons (which...

It has been a few days so you may already have found a solution but if not then I think all you need is the FAQ in the "Micrsoft: Access Forms" Forum. Look for: How do I limit the contents of one combo box based on the selection in another? -Submitted by RickSpr It is near the...

Does anyone know if there is a method that performs the same function as the escape key when entering new data in a datasheet? I have a subdatasheet on a form in Access 2000. To add a new record to the datasheet a user would begin typing in the blank cell on the last row of the datasheet...