Search results

See attached - both are actually showing values of zero, not one. I still think it must be to do with the date values on the data worksheet :-s

Thanks for your replies. Both of the above seem to work fine in Excel 07 when I tested it at home last night. But trying it on my master document today in Excel 03 they both return a value of 1. Any ideas? :-s

I have a column of dates in the following UK format: 19/07/2007 15:00:00 I'm trying to calculate, on the fly, the number of cells with a date over 56 days ago. This is the closest I can logically work out myself: =SUMPRODUCT(--(p_Network!$D$2:$D$50000<DATEVALUE(Today()-56))) The cell...

Is this possible? I have a query which gives 5 fields. I have an excel file formatted with a specific layout and 5 empty cells for the query results. Is there any VBA I can use to copy the query data to those specific cells on the fly??? v: Office 03

Sorted, wbDst.SaveAs FileName:=strNewWorkbook did it :-)

I'm using the bit of code below to combine the first worksheet of every workbook in a specific directory into a single workbook with multiple worksheets. This works OK so far, the only thing I'd like to add is to Save the resulting xls file into either the same directory or another specific...

I've simplified the statement to make it easier. Suggestion 1 doesn't work, unless I've messed up: SELECT * FROM p_Overall WHERE p_Overall.Brief_Description Like '*"["ABC123"]"*'; Also tried & failed with: SELECT * FROM p_Overall WHERE p_Overall.Brief_Description Like '*'['ABC123']'*'; Not...

I need to use square brackets as part of the criteria in a LIKE SQL statement. The criteria is: [ABC123][SR] ie, find all records which have that as part of a longer text string. How can I amend the SQL statement below to "escape" the square brackets and treat them as part of the string...

Got this sorted.

Here is my table structure: tbl_Questions ---------------- Question_ID (autonumber) Topic_ID (lookup) Question_Title Question_Number (and a few other irrelevant fields) What I'd like to do is populate a listbox with all records from tbl_Questions which have a certain Topic_ID, ordered by...

Ignore that last query. Just added this line: Forms!frm_Add2!Topic_ID.Value = strTopic_ID Thanks chaps.

That sounds perfect. I've already grabbed the Topic_ID and stored it in strTopic_ID as follows: strTopic_ID = DMax("Topic_ID", "tbl_Topics") 'only 1 person uses the db at one time I've used the following code to open the next form: DoCmd.OpenForm "frm_Add2", acNormal, , , ...

I'm only using the primary key from the record created on frm_Add1 to add into another table on frm_Add2. Basically, I want people to be able to create a Topic and then create a question (which goes into tbl_Questions). The two tables are linked by the Topic_ID field. So frm_Add1 creates the...

tbl_Topics * Topic_ID (autonumber) * Topic_Name (text) frm_Add1 has a simple 'Topic Name' field, which is entered and then a record created in tbl_Topics. I have a little bit of VBA which validates and enters the record, closes frm_Add1 and opens frm_Add2. On frm_Add2 I will be entering data...

Cheers bud - that was nice n easy!

I'm looking for some code which will show a certain form button IF SQL criteria is met. Basically, I have user data in a table with one field being 'Admin'. If the user which has logged in to the database has a 'Yes' value in the Admin field then I want the button to show. Otherwise it should...

Not sure if this is a 'query' query or a VBA query to be honest. I am making a quiz/assessment system. I am at the stage whereby my database can take people through a number of assessments and record their answers. I now need to work out how to check their answers against the correct answers...