Search results

Thanks James I tried your code in Immediate Window and it doesnt work. I have decimal numbers like 55.68 ...or 345.74....and I want to get 0000055.68 or 0000345.74... Lenght should be 10.

What if there are decimal places...i.e 53.69

In Clipper there is a function REPLICATE...which means adding leading zeros to some string to get desirefull lenght...for example REPLI("0",10-LEN(string))...What is correspond function in Access...Please Help

There a couple of records in a split from. I want to send them to a .txt file using Function key F2. How to do it..Please help

Dim rst As ADODB.Recordset Set rst = New ADODB.Recordset rst.ActiveConnection = CurrentProject.Connection rst.CursorType = adOpenStatic rst.LockType = adLockOptimistic rst.Open "Select * from tblFAKTURI ORDER BY FAKTURA" Dim rDATUM As Date...

Thanks DCrake I think you are right and gave me an idea..where can be my problem...I use MoveNext method when EOF proeprty was True and got an error...and executing this procedure once more time I got this message.. Thanks again But how to avoid in a Do While Not rs.EOF...MoveNext ..Loop to...

Thanks Drake But I expect answers not questions..these message appears for three days..Where to look for locking files?

n a module of setting Recordsets code stop at this line Set db = OpenDatabase("c:\op\mat.accdb") giving me this error: "The database has been placed in a state by user 'Admin' on machine 'RADE-PC' that prevents it from being opened or locked" What should I do to solve this.. Thanks

In a module of setting Recordsets code stop at this line Set db = OpenDatabase("c:\op\mat.accdb") giving me this error: "The database has been placed in a state by user 'Admin' on machine 'RADE-PC' that prevents it from being opened or locked" What should I do to solve this.. Thanks

Hi Brien The invoice number came from a string made of month of date and starting number 01..i.e month(date) & IIF(len(format(number))=1,"0"&format(number),format(number)) The value in CODE field can vary each month..

As I said..this is just an example...the problem is I don't know what the Code should be..but I know what the starting number of Invoice should be...I need something like this .. do Until rs.EOF() rcode = rs("code") do while rcode = rs("code") do updatiing loop 'change...

For example I have 20 records in a table with two fields...Code and Invoice 5 rec with code '037' 6 rec with code '223' 9 rec with code '280' I want invoice to be updated with '0201' for all code '037', '0202' for all code '223' and '0203' for all code '280' with a looping I made a looping but...

I tried with three same numbers of invoices and three different dates but always gives me the values of the second column but first row..How can it be?

NO..I need second column but the value of the current row, but it gives me the value of upper row..It happens only if the invoices are the same, if not, everything is in order..

This is what happens...the numbers of Invoices are one below other and the dates are different...I use a hidden fields as a criteria but it gives me the first date above...not the date of a column...if I choose another invoice it is OK...but not with the same number of invoice..Very strange...

Very wise..thanks...I understand it

My combo in a form has three column. First column I use as Criteria in a query in the field Invoice, How can I use second column as Criteria in the same query in the field Date. Very often happens two invoices with the same number but different date. I need to separate this invoices Please help

How do I carry forward the current value of a control so that it's automatically entered for all new records?

Until I find the solution.. But I am getting closer to the solution...if not possible in the query than it is possible in VBA.. Thanks

What Criteria should I put to group records by 100 records in a Total Query