Search results

This is a very tough problem to explain. Please ask any questions and i will do my best to answer them clearly. I have the following dataset in a table called NR_PVO_120. How do i pick out a number (which can change but let's say, 6) of UNIQUE OtherIDs without excluding any OtherIDs under any...

Hi, i'm running a module from an access db. how do i import a table from oracle into a closed access db, not the one where the code is running from? thank you

hi, i get the attached error message when i try to import an oracle table using VBA. in some database i'm able to go ahead if i compact and repair but in this current one - nothing helps. which table can't it find? can anyone help? i can upload my db but you guys don't have access to our...

Hi, how do i make sure that parent form has a current record? i have no problem doing it as long as the parentform has ALLOWADDITIONS enabled, but in my case it's disabled and i tried every trigger i can think of - and if there's no records in the parent - the user can still click the ADD...

hi, i did try researching this but probably didn't google the right words. what happens if the form timer event is set to every minute, then it fires, procedure runs and it takes 5 minutes. do the next 4 times get skipped or what happens? thank you

i use setwarnings on opening of the database and never turn it back on. i want it to stay permanently off. i don't know if it's a coincidence but since i moved the BE to SQL server - the warnings turn back on after using some forms. i'm getting the "are you sure you want to replace the table"...

Hi, another (3rd so far) problem when something worked with an Access BE and doesn't with an SQL BE. i was using Allen Browne's LogError procedure to log all errors to a table so i can review and fix them. once i switched to an SQL BE - the errors don't get logged. every single error goes to...

first of all, i apologize, i converted my db to sql server and keep having problems so i've already posted and will keep posting more questions. IIf(Not IsNull([SVCSETSSERVICEITEMS].[RefFIeld]), IIf(Not IsNull([RefFIeld]),[RefText]) & DLookUp([RefFIeld],'QFilesServices','ID=' &...

Hi, i have this problem that if the hugest pain for the past few months. i finally got it to work, finished the project, migrated to the sql server and now it's not working. i'm assuming it's because the sql server has stricter rules??? anyhow, i need a combobox that's based on an id but...

hi, how do i add numbers to row in the following manner: if 4 rows have the same number then one of them should be 0 and the rest 1, same for all others. basically, the code should look at the value in the table, if it's the same as the row before add 1, if not - 0 (i think i got the logic...

when migrating from access backend to the sql servier, do the AutoID numbers stay the same? or the numbers will be random autoid numbers in order? for example, in access, if i was to append a table with AutoIDs into another table with autoids and actually append the autoid field - it'd accept...

hi, how do i limit the number of characters in a field in vba. limiting it in a table doesn't work for me because the same field has to accept different number of characters depending on a value in another field so for example, if the value in that field is 0 then the field should accept 40...

i have more than 1 question and not sure if i should open a thread for each question or if combining them is ok. if i shouldnt've combined them - i'm sorry. 1. is there a way to create an ODBC connection by code? so that i don't have to go on every computer and create the ODBC connection (I'm...

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...

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 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...

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")...

hi, i need to get all possible 2 digit combinations (order doesn't matter) or numbers from 1-70 gemma, you did this for me before but it was a little different because i needed all digit combinations and the range was froom 0-9. i could've went back and tried adjusting that code but i remember...

i apologize for the size of the db, i don't know what's making it so huge, i took out all i can. this is driving me crazy, the subform keeps going to the first record no matter what i try. try updating Ttl amount, Rate amount, quantity, Rate quantity, and see what happens. on after update of...

Forms!fclients.Visible = True if i want to replace FClients with me.openedfrom or a variable OpenedFrom. how can i do that? thank you