Search results

I know this is dredging up an old topic, and I am aware some people find this irritating (Not sure why though) I have a similar issue, and if i understand correctly; Are you suggesting that one should call the subform to be loaded on an event from the mainform (such as a control) or during the...

Yep - works fine now. It's a pain to have to go back to the old ways of doing stuff. Thanks heaps. I'll have to post a few bits of tricky code I have put together sometime and contribute to the forums myself.

Facepalm time... I have seen this many times before (using wizard generated forms), and had forgotten as 2007 does not seem to suffer from this illness. Thankyou for the reminder - it appears that the control was indeed named ID. I can't check it right now, but I'll make sure I drop a line...

Unsure of the exact message, and yes I realise this is an issue. Finding out means a 20 minute trip and an appointment to see my client. Have not tried me.ID, will add it to the list of things to try. I'll compile a few test code snippets and comment them out for testing when I am on-site again.

Acviewpreview appears to work fine in 2003, this is not the issue, however I have seen more crazy things cause errors in access. Will try that.

That's an obvious statement, however given my current situation, this is not possible. I do however test at each stage of the project, to ensure these features work. 99% do, except for the above mentioned one, which has been uncovered by extensive pre-testing.

Hi, I'm currently designing a database. I have a main table and a one - to many related table. The main table (MASTERTABLE) stores details of a group. The related table (Presenter) stores meeting records. I'm writing this database in access 2007, but in 2003 format as the end result will be...

Just thought I would post my working code for those trawling the net in search of answers like I do. I added some check boxes to allow for automatic adding and subtracting as I scan objects. I also fixed my routine that will add a new record if an unknown barcode is scanned, and set it's stock...

First answer worked. I used msgbox foundornot as a temporary output, and it shows 0 for not found and 1 for found. Thankyou very much - been at this for two days, with mountains of stock piling up. I can at last get on with the work. I owe you one.

Thanks for the input, it has led me to a new way of doing things, but I dont seem to be getting my syntax right. I have tried a few ways, and have settled on the last one being the correct. stock is the table in question. ID2 is my primary key. barcode is the column I wish to search strName is...

Hi, I'm currently designing an inventory system for my workplace using a barcode scanner (software keyboard wedge type). At present I have it use the prefix CTRL + B On my form (access 2007) I have the keypress event monitor for the acsii code for CTRL + B (Ascii 2) as this appears to do...

Ok, well i got it working for now. Not as perfect as what I had hoped but it works as a stopgap until I have time to improve it. I found a couple of hints here: Playing a Wav File in access: http://www.tek-tips.com/faqs.cfm?fid=251 DTMF tones in WAV form - for those too lazy to do it...

I seem to be having some issues finding exactly where to download the sample apps from microsoft. So far all I have found is how to either detect dtmf, or how to dial to a com port. I getting to a last resort here and embedding a .wav file for each dtmf digit and play them back with a big...

Hi, I currently have a job management system I have written for an electrical services company. Specs: access 2007 OS: Vista (tell me about it) What I want to acheive: I have a contact list for our staff, I would like to be able to click on a number, and have it generate the DTMF...

I know this is an old thread, but i just crossed paths with it in search of ther more pressing matters. Just wanted to take the time to thank everyone who posted. You all put in considerable time it seems, and it did help me resolve my issues in the end. So thankyou once again everyone.

Just for the benfit of those who contributed, I did finally get this working. After a long rodeal struggling with access, I ended up turning to vba in excel. This meant one less step. The coding operates a little differently, but the basic functions appear to work just as well in access's...

When I first made the post, I didn't have the whole story myself. I simply had a pile of data thrown at me and given the task of interpreting it. I would point out that replies here are optional, and if one finds this topic irritating, that they are under no obligation to reply. My original...

I have to thank everyone for their wonderful input. I have managed to get my data chopped up into managable portions using fixed delimiation when importing into access. The code provided has assisted me in sorting out the anomalous data left behind. This isn't going to be an ongoing thing...

I must have accidentally pasted my manual transcription. I have manually added the spaces there to values I could astertain as correct. Unfortunately, I don't recall a "q" anywhere in it. The untouched strings do not contain spaces. - hence the difficulty.

Ok... this certainly turned into a complex topic in a hurry. The number of 45 may be incorrect, as I based this on an average count of morse characters, on the few "packets" I have been able to translate manually. 45 represented morse characters, and they are 21 real characters. The...