Search results

Hi All I have searched online in a number of forums and although I can see how to pass a parameter to a query a) either you a form value b) to a SELECT query non of the above are applicable in my case. I have 10 append queries that dump their reults into a temp table TEMP2 where I extract...

Good day all I am trying to export a given table TEMP to a CSV. The docmd.transfertext works great but the problem I have is that I am trying to open a recordset to count the total records in the table TEMP. Export up to 20k records to one csv after which create a new file and export another 20k...

Good thought Jdraw. Maybe I should have mentioned the point that the length of the mastersheet asset_id is variable and thus can be of length 4 - 9. Any other suggestions on this are much appreciated.

Hi All This is a tricky one so please bare with me. The idea is I have two tables Master_List and PBO_List The PBO table has two of several other columns namely pbo_asset_id and pbo_count I use this table to run inventory on some bar codes. If a bar code is scanned, the pbo_count (of datatype...

VBA Thanks for getting back..and thanks for your patience. Just so we are clear I am showing you what I have for a) the save event where I have commented out all my error trapping and b) on error event where I am trying to specifically trap the DAO Error only. The On Error event to my...

It is a form error and like I had mentioned earlier, I am able to trap the application side (see attachment) as runtime error 3146. I am having a problem specifically trapping the DAO Error. Access only throws a runtime 3146 which could mean anything. I need to error to trap the particular...

Thanks for your response Not following what you mean by.. I know I do have the option of running the data validation in the code on an after update event but I also wanted the option of trapping it as an error when the user tried to save the record. What are your validations against this...

Good day folks My access program connected to SQL Server has a table tbl1 has a composite key (col1 and col2). Naturally these two will not take duplicates. I have code that is set to trap duplicate entry errors as below. Private Sub cmdsave_Click() On Error GoTo err_duplicate '....some...

Hey Apr First off thanks for looking into this for me. So after posting this thread, I went back into Access and did something pretty similar to what you had running by opening the specific recordset and creating a loop for multiple inserts where condition qty > 1 was true. Please see my code...

Hello All I have an excel sheet that we have to download from a given source and I am using access to populate this record directly to SQL server to be used by a barcoding label app. The problem I have run into with my app is that each record inthe sheet has a quantity column attached to a...

I'll have to troubleshoot to see if the code is actually sending the message to the server with SA. Just wanted to see if there were any issues with the code I may have overlooked and right now its looking like the issue may be beyond VBA. Thanks for checking on this for me John. If you have...

Hey John Thanks for getting back. I intentionally removed my server IP settings and other values (eg someemailaddress). You never know who to trust these day. On your second note. I have been reviewing my code and adding and removing some other fields like you suggested. Although I have...

Guys can you please take a look at the below code and let me know your thoughts. The first bit errors out to runtime error 2147220973 "The transport failed to connect to the server" 'This code is courtesy of Ron de Bruin www.rondebruin.nl/cdo/htm 'The code will send an automated email to the...

FYI (Edit) - I have noticed on further testing that leaving the system plugged in for about 10 minutes will allow the tables to be refreshed fine. Is it normal for this to happen and not fire the refreshlink immediately?

Good day all I have a access 2003 front end linked to sql server tables. My app is a field system that allows for users to go offline and work of local tables or come back online and work off the linked tables. I have a form that runs the necessary code to check the status of the current...

Hey Jdraw Thanks for your update. Well embarrasingly, this is actually the first event I had tried running my code on. The scanner however wasnt programmed to throw a carriage return after the text box was updated so naturally nothing was happening after a barcode was scanned. I spent the next 6...

Hey This message was posted in a wrong forum area earlier and I had to move it over here. I received a response from JamesMcS adviced to put my code in the textbox onchange event. Well this event fires as soon as the first character is scanned into the system and I need to capture the whole...

Good Morning All I am trying to move forward with some new features to an app I am building for our asset management system. I have a textbox field on a form that gets focus on load and the idea is for a user to scan a barcode (device serial) into the box. On clicking the search button next...

Hey James Although I know there wer probably 50 ways of doing this, I am actually liking the linked excel version the most. I attempted with creating a transferdata macro but that had too many arguments that were at this stage variable. The link I have created allows me to use this sheet as...

This is more of a pick your brains but lets assume a table Devices exists in my database and 2 of the 8 fields in that table are Device Serial and Device User. I also have a master xls sheet with a number of columns which also includes these 2 fields ie device serial and device user. What...