Search results

What did your excel-generated list looked like? When you say ??#13-0001 up to ??#13-1500 what exactly do you mean? Did you have like this? BS#13-0001 BS#13-0002 ... BS#13-1500 LS#13-0001 LS#13-0002 ... LS#13-1500 BP#13-0001 BP#13-0002 ... BP#13-1500 If yes, then your SQL should work...

Hi, Could you give more details on options and "data entry boxes", like : if schemes=4 then sheme1 and sheme2 should appear if schemes=1 then sheme3 and sheme4 should appear etc. Also are sheme1 ... schemeN bound or unbound textboxes (i.e. do they have table field behind) if bound, are they...

If you have access to the database only once in a while then why don't you import (instead of linking) the table into your file. You can always "re-import" later with newer data when you get access again.

Try to use WHERE instead of INNER JOIN.

SELECT * FROM [table of skills] WHERE [SKILL1]=True ... Change [table of skills] to real table name Change [SKILL1] to real skill field name

Hi again, Here is what you do: Step1: Create table with sequential numbers. Either do it with Excel and import to Access, or run the following code: Create module, paste the code and press F5 Sub CreateSeqTable() DoCmd.SetWarnings False DoCmd.RunSQL ("SELECT 1 AS SeqNumList INTO tSeqNums")...

What abot this? Private Sub Text1_AfterUpdate() If Me.Text1.Value <= 0 Or Me.Text1.Value >= 100 Then MsgBox "Can't be nil nor equal or greater than 100" End If End Sub

This should return days left until birthday CDate(Format([dob],"dd/mm") & "/" & (Year([dob])+65))-Date()

Add DESC to your ordering: ...ORDER BY T.INSPDATE DESC)...

And this is the SQL SELECT [How they heard a...], sum(Revenue) as SumRevenue FROM [Revenue per car purchased] GROUP BY [How they heard a...] You need to change [How they heard a...] and also table name [Revenue per car purchased] if different.

Why don't you first Link table(s) from one database to another and than build normal query between linked and local tables?

Hi, You cannot enter data into aggregated/grouped query. May I ask why do you make such a query, what is the aim?

Hi, Not sure if I got you right, but what do you mean by "...I don't have a persistent connection...". To pull data from one Access file to another you have to link tables. If you have intermittent connection (lets say once a day) then you could import table or just make local copies of the...

Here is the small modification which will remove numbers higher than the last CaseNumbers SELECT "AB#13-"&Right("000" & [SeqNumList],4) AS MissingNums FROM tSeqNums LEFT JOIN (SELECT CaseNumber from MainDataTbl where CaseNumber like 'AB*') as AB ON Right("000" & tSeqNums.SeqNumList,4) = right(...

Do I get you right, you have the following: AB#13-0001 AB#13-0002 ... AB#13-1234 and CD#13-0001 CD#13-0002 ... CD#13-1234 and EF#13-0001 EF#13-0002 ... EF#13-1234 Is this correct? If it is, then the following should do the trick: SELECT "AB#13-" & Right("000" & [SeqNumList],4) AS...

Hi, here is the "dirty" way to do it: Assuming that last 4 digits are unique in your Casenumber, you need to create a table which contains all sequential numbers. There is probably the way to do it with VBA, but quick way would be to do it in Excel and than import. If you call new table...

Ah, thank a million Paul. So simple when you already know...

Dear All I have a feeling there must be extremely simple solution, but I spent whole day without success. I have a form with combo box [Combo18] with the following options: All V01 V02 V03 After one of the options is selected I want to run query, where criteria is based on the selected value...

Well, I am already sorry for 193 fields in one record, but that was only way for me to do the following form. I am still open to suggestions, if anyone can achieve the same shape of the form with more elegant table behind. P.S. OCR and/or other options are out of question in this case.

Thanks everyone for effort. I tried every idea, but finally decided to do it "wrong" way (everything in one record). That was the only way to achieve what I wanted.