Search results

I have the following line of code in the form_Current event of my main database form. Me.[FollowUpDate].Value = Me.

Paul I did just notice that when I click in the FollowUpDate text box on the form, the entry changes from say 14-Mar-05 to 14/03/2005 20:29:53 so it would seem that there is some time element being saved. All the date controls are formatted as medium date. Is there some input mask or other...

Paul Please advise what you need to see as I can't upload full DB as the zip file is too big. Thanks VC

Thanks I decided to use code to calculate the FollowUpDate using the form_Current event and the following line of code. Me.[FollowUpDate].Value = Me.

Date text box on form Good Afternoon Guys I have a text box on a form which, when the form is ready for a new record to be entered, displays the date which corresponds to the Monday of the following week. I need this date to be saved in the record as a follow up date for quotations. The...

You are being a big silly Girl aren't you. You will be replying to some more posts dear boy because you'll never know it will be me posting. I've got a few identities for these forums. I will expect the same low calibre replies from you though.

Thanks. :)

Thanks That sort of helps but I would like the date to appear by default without having to increment like you have shown. Thanks VC

Hi Dudes I have a text box on a form which is formatted as medium date and I want it to default to the Monday of the following week. So for today it should have 07-Mar-05 in the text box. Can anyone please advise a method for this. Thanks VC

Works fine, thank you for your help. VC

Thanks Brian I see what you mean but I need the user to be able to go to specific records when the form is open, not when the form opens. So I have created on my form a text box (txtGoto) where the user enters the required record number and a command button (cmdGoto)to go to the record. I...

Brianwarnock Thanks for your suggestion, I tried this using a new text box on my from and a command button, the following code to run the the cmdGoto click event. Private Sub cmdGoto_Click() stLinkCriteria = "[Record Number] = " & Me![txtGoto} End Sub Is this correct as I couldn't seem to...

I have created a form on which the user enters or ammends records in the main table of the database. One of the fields displayed on the form is the record number which is an AutoNumber and the primary key of the table. This is updated when a new record is created and can't be edited on the form...

Hi Can anyone advise me on the following. I need to use a series of combo boxes on a form so my user can select certain criteria for a search query. What I need is for the first combo to dictate the contents of the second depending on what was selected. For instance if "France" was selected...

I have a table that contains customer details such as Account Number, Account Name & Phone Number etc etc. On a form I want to create text boxes to display/change the information. In the first text box (this will possibly be a combo), the user will enter or select the Account Number and I would...

llkhoutx Thanks, I have edited the SQL and the query now returns no records if I run the search after checking the box. Can you edit my SQL and return as an attachment and I'll try that. Otherwise do you think it would be easier to use a combo to select this. Thanks VC

llkhoutx Thanks I know what I need done, I'm just not sure how to ammend the query or the SQL. The SQL for this query is quite involved already (see enc word doc.) Do you know SQL and can you advise. I basically have a field in my table called "Project Status". So on the form when the user...

Can someone please advise me what the VBA event is when you scroll through records on an access form (ie when each record is opened). Thanks

Col Thanks, this works fine when I'm entering the records using the form and the correct entry (Live, Lost or Won) is entered into the table and also displayed on the from in the relevant text box. When I go back into the form, although the correct status is displayed in the status text box...

Good Afternoon I have a custom pop up form set up as a query dialog on which a user will enter or select certain criteria for a search query. This is done using text boxes and combo boxes. How do I use a check box on the form to exclude certain records from the search. For example tick to...