Search results

thank you very much, i found it in case someone needs it, this works perfect. and here's the thread http://www.access-programmers.co.uk/forums/newreply.php?do=postreply&t=215372

Hi, i'm working on a database that transfers data from Access to Quickbooks. here's the problem, instead of having one long field for Company name, another long field for Address (not including City, State and ZIP) they have Company name field 41 chars long and 6 address fields 41 chars long...

didn't think to look at the Dim)))) but i understand now, it really is that simple once it's explained. thank you so much for the code!!

Public Function tst2345() DoCmd.RunSQL "DELETE * FROM mtSkippedFileNumbers" Dim FirstNo As Integer Dim LastNo As Integer FirstNo = DLookup("First", "QFileNumbersStartEnd") LastNo = DLookup("Last", "QFileNumbersStartEnd") Dim rs As Recordset Dim a() As Boolean...

i think i understand why, will try to fix and post if it works

everything is perfect except one thing, the numbers i gave you will always change (10000 to 11000) and your code needs a constant. i don't understand why and because of it cant fix it))))) but once i put the numbers in - works perfect of course again, thank you and this is not a big deal, only...

i just woke up and about to test it out)))) i thought about creating the table but it just seems so unesthetic))))) if i couldn't find anything else i would)))) but i see what you're saying that there's no easy way to do it but to test the numbers one by one. about to study the code to...

Maybe i'm misunderstanding how to use it but it's not working for me. In the meanwhile i got everything to work some very ugly and shaky way so i'd like to just have it redone. What can i use to identify missing numbers in a range and generate a list of them?

a table would be perfect

i need to be able to create a list of all numbers skipped in a range of numbers so for example from 10000 to 11000, the range will be different each time. i found an example on the net that tells me where there's a gap but a now need a way to generate all the numbers in the gap. i don't...

this is amazing, t hank you so much!!!!!!!!!!!!!

damn, and i tried dlookups, just not this way thank you so much!!!! will try and post back

it's not possible?

this is probably not possible but never know i have a field in which i store names of fields used for the record's calculations. for example, ID CalcFIeld Percentage 1 LCTtlAmount 5 2 LCAmdAMount 4 3 LCTtlAmount 3 the entries in...

but i'm getting this error even on a computer that has skype installed.

Hi how do i not only late bind skype SKYPE4COMLib driver but also check if the user has skype installed and don't do anything if they dont the below gives an error on the 2nd line "ActiveX componenet can't create object" Dim sky As Object Set sky = CreateObject("SKYPE4COMLib.skype")...

Option Compare Database Option Explicit Dim result(1000) As String Dim maxresult As Long Function combine(required As Long, max As Long, combo As String) As String Dim x As Long Dim startfrom As Long Dim newstr As String If Len(combo) = required Then maxresult = maxresult + 1...

Gemma-Dave is not answering yet, do you want to look at his code and see if you can change it so that it goes over 10?

i learned after the last time he helped me)))) and saw the pic of the dog, shes beautiful))))))))))) But i don't know him close enough so i call him by his nick

Gemma, if you come across this, i'd still would love to have an update for your code that goes over 10. it was so elegant....