Search results

Just for my info. I have two Functions that give a result for the last digit of a UPC-A and result for an alphanumeric for a UPC-A font. When I look in VB there is a Sub for each one also. Why?

Dug from the archives (where it probably should have stayed ??)! Have you ever wondered who first uttered the phrase "You Gotta Be Shittin Me!”? Well, it just so happens to have originated with the Father of Our country, way back when George Washington was crossing the Delaware river with his...

I checked my virtual memory in Windows 10. It was set for a minimum of 16 megs and maximum was set for 1861. I changed the minimum to 2048 and maximum to 4096. Restarted and put Access 2007 through an intensive session of form changes, creating forms, queries. NO PROBLEMS!

I did all of my reports with queries. Design a query with all the fields required. Set the Criteria to the information needed and produce a form with the fields you need. Add subforms based on other queries if the result requires.

I installed the SP3 for office 2007 and tried Access. No problem....yet

Thanks, but I think I'll leave my other code alone. It works. Just thought I could be more efficient.

Is there anyway to accomplish this Excel function in VBA? A5 =0, returns P A5 =1,returns Q A5 =5,returns U etc... =LOOKUP(LEFT($A$5,1),{"0","1","2","3","4","5","6","7","8","9"},{"P","Q","R","S","T","U","V","W","X","Y"})[/CODE

Thanks for all the help. I found an update CAB for Access 2007 in the Microsoft update catalog. I'll try soon.

Thanks for the help. Found the info. This is the most recent (8:06) This morning Faulting application name: MSACCESS.EXE, version: 12.0.4518.1014, time stamp: 0x4542815c Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000 Exception code: 0xc000001d Fault offset: 0x0112c608...

Merry Christmas! Thanks for the replies. Db was created in A2007. No A97 within a 100 miles. Doesn't seem to be any one thing that causes the crash nor the hang problem; opening forms, forms in design view, running queries, queries in design view...

Hi all! Been away from Access for 12 years. Lost my hard drive along with Access 97. Recently bought a Office Pro Plus 2007 for a couple of $$ with Access. Quite a difference in the look and feel. Got a db set up for my wife with very few problems. The main problem I have is Access hangs for...

Happy that was all it was ;-) Now I have found my Access code is all messed up. Something seems to have changed the ASCI numbers in my code. And , as with yours, my Excel works fine.

Vin, ean13 is a 13 character barcode. 12 digits and a check sum. I don't think 9 numbers will work. Try entering 3 numbers at the beginning as i think the code auto adds the check sum to make 13.

should be; Function name cannot be the same as the "Module" NAME

One possibbility. The functio name cannot be the same as the name in the textbox .

I also used jean marie's code ean13 for Excel but not for Access. have you tried tweaking the font size and/or the text location? I retired and haven't used Access for several years, but I remember the same issue with my code for upc-a. I changed the text box text location from bottom to top or...

I hurried and negelcted to account for "100" being part of "1000"... jim

Meltdown, create a query with all the fields you need for the output. In a blank field place Product100: InStr(1,[productcode],"100") in the criteria section insert a >0 symbol. THe instr function gives the position of the first occurence of the string. With the > 0 it gives the location of the...

labels I doubt there is a solution to the "20-30" blanks when you are doing your report. However, if you create a new query and report for "Blanks" and link them to a Command Button on your Form: Change the text color of the "namefield" to None or white and add this; I have to still credit...

wreck, in the "OnExit" of your subformtextbox; Forms![yourmainformname]![textbox]=Forms![yourmainformname]![yoursubformname]![textboxofsubform] jim