Search results

Hi all, Please help me correct this criteria for a filter in my query. I want to show all records between todays date and the past 14 days. I've tried, Between Date() and "Date - 14" And it dont work. Thanks for any reply.

re: Please any ideas. I have searched the forum for a answer.

A record is created in my table (TEST Data) when i hit the save button on my form. The record is created, and the suppliers name as an example is "Phils Cables", now i want to automatically create a duplicate record in my table with the same information i just saved, the only difference being...

Re: i would like to use the above Lotus sample code for a project i'm working on. Could someone help a newbie and put it in a sample database so i can see how it all fits together? thanks

Thankyou Thankyou bob! i really was pulling my hair out on that one!

Hi all, i'm using the code below to try and return the workdays between begdate and enddate. Values get loaded via 2 textboxes on form. The function itself works fine, but i cannot get the calculated Work_days (at bottom of function) to display on a 3rd textbox on my form. The function is this...

Hi all, i have a search function on my form, and the search will filter the records i have from a table when i click the ok button. This works ok, however, problem is, when i load the form up, the page is filled up with records? how can i show no records when the form loads up. Thanks

re: Hey Spasticus, your bit of code will filter if true or false. The fact remains there is no condition to make "DELIVERED" False after 7 days after the delivered check box is ticked on my form. Remember, i have to test the condition of about 100 records once the open report button is...

re: In a report mate. At the momemt a button on my form opens the report. The report gets its data from a query. The query gets its data from a table. The query presently has its "delivered" criteria set to "False" thus it only returns outstanding records. I now want to add the feature as the...

re sorry i am a noob mate! where do i put the code ? in the criteria? coz it looks like vba to me? cheers

re Ok when i save the record now and if delivered = true, it will write the del date date in the DELREC column in my table. The code below is great to test the condition of one record, by my table consists of about 100 records. i loading my table into a query, so its there where i am trying to...

hey all, I have a query with a few columns one of which is a called "Delivered" . Delivered is a check box entry, which at the moment has its criteria is set to "False". The report this query generates will only show records that have not been delivered. i.e Outstanding records, because...

re: Can anyone help me or is this a pig of a job?

How do i Copy Listbox selection to another part of form? Can someone help me out please? On my form (attached) i have a listbox on the right hand side. What i want to do is that when i click on any selection in the listbox, it will add it to the list on the left. The listbox (or whatever) on...

Figured it out in the end! must be in this format to work If Not IsNull(Me.BDAY) Then strWhere = strWhere & "([CARD] = " & Me.BDAY & ") AND " End If A right bugga!

It compiles ok, but the result it gives is not what im after! Basically BDAY can be 5 digits long i.e 100000 if 100000 exists in column CARD in my table then i want to display the filtered record on my form. If no exact match is found then i want to show a msgbox. "No record found" cheers

re: Thats what i thought mate but its the syntax that im struggling on. Can you show me how to write the line correctly without the "like"

Hi all, looking at the code below, i enter a string in "BDAY" textbox and hit search. If will find all records with part of the string in the CARD column. How do i modify it to find an exact string match. thanks Dim strWhere As String 'The criteria string. Dim lngLen...

re: Hi mate, Put this vba code in the search button on click event procedure Private Sub cmd_AddSong_Click() DoCmd.OpenForm "frmsong" End Sub

Re: Hi mate, you dont need a query to do this. You can do it with a bit of VBA! I've added a couple of names in your table and added some code behind the search button. Type in a persons surname in search and press enter, and it should return the persons record.