Search results

I finally got it to work. I had issues with date format: I'm using European date format dd.mm.yyyy instead US date format mm/dd/yyyy. I corrected the code and it's working now: LineItemNumber: DCount("[InvoiceNumber]";"sub_InvoiceLineItems";"[InvoiceDate]<= DateValue('" & [InvoiceDate] & "')")...

This is the SQL syntax I have: SELECT ReceiptsData.*, DCount("[InvoiceNumber]","sub_InvoiceLineItems","[InvoiceDate]<=#" & [InvoiceDate] & "#") AS LineItemNumber FROM ReceiptsData ORDER BY DCount("[InvoiceNumber]","sub_InvoiceLineItems","[InvoiceDate]<=#" & [InvoiceDate] & "#"); This gives...

Actually when I turn SQL view it's commas... The error is this: Syntax error in date in query expression '[InvoiceDate]<=#7.3.2041.'. -> european date format.

I get syntax error with this code: LineItemNumber: DCount("[InvoiceNumber]";"sub_InvoiceLineItems";"[InvoiceDate]<= #" & [InvoiceDate] & "#") I cannot get it to work! grrrrrr

I actually knew that and tried it but didn't put # sign in double quotes. I'll give it a try now.

I've replaced InvoiceNumber with InvoiceDate: DCount("[InvoiceNumber]","sub_InvoiceLineItems","[InvoiceDate]<='" & [InvoiceDate] & "'") AS LineItemNumber It gives me error.

No, InvoiceNumber are closely tied with the SAME date. If you have more than one (not more than two actually) InvoiceNumber's they will have the same date. I was driven by your logic but was unable to produce correct sorting...

Super done. Excellent. But, I'd need to have line item sorted by date... Yes, I have InvoiceDate field too. I tried to get it working, but no luck. Any input there? I noticed you were sorting them by InvoiceNumber from smaller to bigger. Normally it would be good, but in my case I actually...

You are correct. As I was retyping I made mistake. last row number 6 is this: 2332-9000-14. Thank you for noticing this error.

OK, here we go: Table name: ReceiptsData I need to check if this table's field InvoiceNumber (text field) repeats on report. Count of record should start from 1, then 2 and so on into unbound field called LineItemNumber. If InvoiceNumber repeats itself then carryover whatever number was the...

So, I still didn't get this to work. I'm mot sure how to make it work. I tried with queries, but no luck. Can someone give me some more guidelines or examples?

Thanks for answer. I'll give it a try. BTW - NUMBER and ORDER NUMBER are purely an exapmles of column names. And yes I do use CapitalLetters without space(s) as column names in table.

Please can anyone help... I want to have line item numbers on report look like this: Number....Order Number 1............9533-1425-20 2............5866-3411-14 3............2332-2355-14 3............2332-2355-14 ->repeating item 4............4399-5208-12 5............7392-2305-62...

Solved! I imported data from excel spreadsheet as they are (all text)it temp table, then did query on that temp table to compare imported data in office field with office table data. I then added ID field of office table that gave me ID number of matching office. Then I ran append query from...

I have this problem: I want to import customers’ names, emails and their office code into my customers table. Names & emails are fine (text), but in my database office field is number as lookup to OfficeID in office table. So now I’d like to have formula or VBA code to check text filed of...

I'm trying to export module directly from one database in to another, but I'm getting error #29068 when using DoCmd.TransferDatabase I was able to export macro (which I need also)... DoCmd.TransferDatabase acExport, "Microsoft Access", strFile, acModule, "basFEUpdate", "basFEUpdate"

missinglinq, This code actually works well, but my problem is that unbound combo moves to next (or whatever selection there is) record of current form as number of macros - there is event AfterUpdate... I'll have to test it and see what macro is doing problems. Thanks, code works exactly...

Hi, all I have unbound combo box based on query. I'd like to have another button which select next record in that unbound combo... (similar to next record in bound form). Is this possible? I've tried using code to select ListIndex of that combo box but it gives me error - Invalid use of...

I have SharePoint list inserted as linked table in Access 2007. When I need to refresh list I need to delete all records in that table and append new records (not all of them are new - some are existing). This works fine but it always shows NEW next to all items (I know why - for this list...

After some testing, errors and trials finally made exactly what I wanted. Thanks vbaInet.