Search results

So what you really want is a date 1 week ahead of the entered date? So it really doesn't have anything to do with weekends. Going to work now, will post that solution tonight unless someone beats me to it. Chris B

Which is Monday is it not? Chris B

Agree. At the top of the All tab of the textbox, the name must be timesstart not the control source which is the next line down. This should be blank. The function Private Sub Command17_Click() timesstart = Time() End Sub works fine for me against a textbox named timesstart. Chris B

=IIf(Weekday(Date())=3,Date()+6,IIf(Weekday(Date())=2,Date()+7,Date()+5)) Should do it. Chris B

Is timesstart the name of a textbox or something else? Chris B

OK, you want it to be the next Monday, hang on a minute - have to do Sat and Sun separately. Chris B

Maybe this =IIf(Weekday(Date()+5)=1 Or Weekday(Date()+5)=7,"Shut today",Date()+5) Chris B

Hmm. Best to ask the question to which you want the answer at the beginning. So, if the result of adding 5 days will be Saturday or Sunday, what do you want it to display? Chris B

Using the above, in the buttons on click event select event procedure and enter textbox1 = Date or Now or anything else. You can use one button for start and another for end, or be really clever and use the same button for both, e.g. If IsNull(box1) Then box1 = Now Else box2 = Now

Use bitmaps (bmp) Chris B

In a text box on a form set the control source to = Date()+5 Chris B

Are you running the inkjet in draft or economy mode to save ink? That will do it. Print in normal mode to see the graphic. Chris B

You have been hijacked. Download and run HijackThis from - http://www.merijn.org/ Post the resulting log file here for analysis - http://www.hijackthis.de/ "Fix" the entries it identifies as nasties unless you know what they are and wish to keep them. Chris B

If you put this in the "On Change" event of combo box called "Input" - Private Sub Input_Change() If [Input] = "Day" Then [StartDate] = Date [EndDate] = Date [StartTime] = #7:00:00 AM# [EndTime] = #7:00:00 PM# Else [StartDate] = Date [EndDate] = Date + 1 [StartTime] = #7:00:00 PM# [EndTime] =...

Drop the table and relink. This time do not specify a primary key. Chris B

In the on click event of a button on a form based on tblSampleFrame, select Event Procedure and paste this code - DoCmd.CopyObject , "tblSampleFrame" & Date, acTable = acDefault, "tblSampleFrame". This creates a copy of the table with the date attached. Then you can runsql and delete from the...

Not stupid. Asking the question tends to get the thought proccesses working. Glad it's sorted. Chris B

I fired up another machine with 2007 and ran some tests. I do not see your issue at all. I suspect that either your db or your Access installation is damaged. First try to experiment with a new blank db. If this plays up, I would repair Office (Add Remove Programs - Repair). Chris B

Hmm. I haven't struck it. I just made two identical forms off a table directly, opened them together and altered records, no problem, also two based on a query no problem either. A2003. What exactly are you doing to get the error? Chris B

You can use up to 7 IIfs nested and as many as you like consecutively.