Search results

I am probably being dumb but I am stuck on a silly problem, all I want to do is when my form opens its sub form which is set to datasheet is ready to add a new record so you can just type straight off. The sub form record source is a string which works fine, this opens at the first record. My...

I got it to do what I wanted in the end by just exporting to Excel and bringing it back, not as clean as I would like but it does what I intended. Its more an exercise in can I do it rather than it must be done, I could have done it an easier way but I wouldn't have learned anything that...

Sorry I didn’t make it clear. When I said ‘pre-existing table with the same field names as used in the sql.’ What I meant was the same field names that had been searched on in the SQL query. In my example Make, Model and Transmission but these could be any name from the Car List table that I am...

I tried this approach and works until I want to pass it the variable field names, what I need is the code to insert into temp (any number variable filed names) from (sql result) Can it be done?

I have spend hours trying to work this out and either to thick, rusting or its very hard :) What I want to do is take the result form a sql query in vba and append it to a pre-existing table with the same field names as used in the sql. My SQL query is Srch = built on a form and in this...

Thanks Rx this is exactly what I needed, your a star.

I need to make the field name created in the ‘as’ statement in this sql a variable I can call in RS.??? What I have so far: - Srch = Me.Select_field & " as " & F1 When run this reads “[Car List]![Make] as Make” which is correct Set RS = CurrentDb.OpenRecordset("SELECT " & Srch & " FROM [Car...

You gave me an idea, I renamed it to adp (which the orginal 2000 file was) and hey presto it opened, so my predecessor had created the accdr from a adp file. Sorted :)

I have an issue where a database has been packaged using the Access 2007 developer tools and has been installed giving the user a accdr file, the issue is that the original source file the accdb does not exist for some reason and I need to modify this file. The person who created this database...

It is something wrong on the PC itself as the db doesn't run even in full blown access but works fine eleswhere, I have tested all the libaries, installed access extras and compared the pc to working ones, I can't see anything wrong its one of those stinkers. :confused:

I have checked all the libaries used and all are fine, some are newer on the non working machine though. Does that matter? This has got me stumped, if it didn't work full stop then yes i could fix it but the fact it works elsewhere fine is odd. The report it is trying to open will open if done...

Good plan, I have installed Access 2007 run time and full blown later for debugging but it does have Access 2000 on board to. I will check all the library ages on Monday, it has to be something to do with them. Cheers..

I have checked my references and all are fine (According to Access) and stepped through the code, it breaks at ADOX.catalog however the code works on all the other machines Win XP and Windows 7 alike. I think missing library even though it says all present but even though i have tried i cannot...

I have an issue with a Access 2007 runtime installed database, this file works perfectly on most machines except two and even on them it will not if full Access. It uses a connection to SQL server to get its data which works as the database opens and allows interrogation of the tables via...

I have a situation where an Access 97 runtime operating database which was running fine on Windows 2000 and Word 2000 has been moved the Windows XP and Word 2003. Now none of the DDEInitiate commands work, all this code did was open the word doc as read only something the users insist on...

I have been asked if I can place an appointment reminder in a specific calendar within outlook, I have been placing appointments in outlook for years using code like this Dim objOutlook As Outlook.Application Dim objAppt As Outlook.AppointmentItem Dim objRecurPattern As...

Hi The code I am using is Set Myset = CurrentDb.OpenRecordset("SELECT * FROM [EmailText_tbl] WHERE ((([EmailText_tbl].ContentID)= " & S & "))") e.g. S = 1 SAL = Myset![SAL] Which is returning '" & SAL & "' as text in the email and what I want is to be able to use SAL so in the VBA the...

This is probably a silly question but its Sunday and my brain hurts lol. I want to get the literal value from a field in code, what I want to do is construct in a memo field a email text with the vba code in so when called in my email module it will act on the code given. E.g. if I type this...

I have a windows driver for the scanner and all works well. I do not want the scanner to input into a field but to capture and store the data in the background unattended. In this instance the barcode is being used as a clocking in device (the clients way of doing things), so i need either...

I need to get Access 2007 to read a barcode reader live, as in take the data as it is scanned and put it in a table. I have got it to create the barcodes for me that was easy but getting the data back in is doing my nut in lol. I have a R232 data logger which saves the data to a text file so...