Search results

thanks, the string works fine for my needs. cheers

I need to create a parameter query which applies a criteria using a short date in the parameter input but the field is a date/time field. How can I wild card the time in the paramater as that is irrelvant? My date field looks like: 14/08/2003 6:50:00 p.m. but I want the parameter to only...

we have an access db that has an automated emailer that uses outlook. With the 2002 outlook and the secuirty work around that we have used it has become slow and clunky. It does work but not very well. Can anybody outline the basics of emailing without using outlook as the server. What servers...

thanks Fuga. got it woking ok thanks

I am trying to create a parameter query to select dates for a pay week but can't find the right way of doing this. I can get the query critria working using: >=Now()-7 this gives me the last 7 days but I need to add the parameter of the last day of the payweek. Any body help? Thanks

tried the expression but couldn't get it working I tried the between now and then but couldn't get it working. This is on the right track but my skill is lacking on this, anybody give some further help? Can't get my head around the diffdate. Cheers

I have a birthday query (SQL) that I want to set an age period when running. We use this to send out birthday cards but have different ones according to age. I follow the query's logic ok but can't change it so that we can specify age groups ie ages 10 year olds to 15 year olds all having...

Can anybody point me in the right direction for limiting a listbox. The rowsource is from an SQL statement which is working fine but I need to limit it to the current record (userid) somehow. cheers

Thanks Mile-O-Phile

I am slowly learning VBA via this board and asking basic questions Here's one: I have a text input box that is reset via a command button using the following code: Private Sub CmdReset_Click() With Me.lstResults .RowSource = strSource .Requery End With End Sub What can I add...

Anybody point me in the direction of a good site for learning basic VBA, other than here of course but I need somewhere I can get the very basics. VBA help doesn't seem to help me much. Thanks

To obvious for me! cheers

I have a great Search form from this forum (Mile-o-phile) which is working very well except the fields in the display change after the filter is applied. It is a listbox with the Row source as: SELECT Members.ID, Members.Surname, Members.FirstName, Members.PhoneHome, Members.Fax FROM Members...

not quite working thanks Travis, got the idea but something isn't right. I will have a detailed look later. I might come back to you on this. Where can I read up on keycalls and code? Regards Rob

Can anyone tell me if this can be done: I have a function opening a form and passing a selected record by a click in a listbox and also want the enter/return key to do the same function. the code used is below (some may recogise bits of it) any pointers? Private Sub...

Cool Thanks, although it was not quite as simple as using the wizard as it was linked to a listbox I got the idea and have used the code to get the job done. Cheers

I have created a search form (thanks to this forum) that locates a particular record, how can I pass this record (via userid field) to another form suitable for editing? I can get the forms closing/opening but unsure how to go about the correct record being loaded in the editing form. Thanks

thanks thanks Pat, you guys are an endless source of learning.

That worked, thanks Tim

I am trying display the results of a query in a list box based from the record viewed in a form. I can get the correct listbox results for the 1st record displayed by running the query as the form loads but other records don't update. I need to run the query each time a new record is displayed...