Search results

Hello All. Does anyone know why tables I have hidden using vba code Application.SetHiddenAttribute acTable, tdf.Name, False keep appearing after a SQL Server passthrough query is run? The tables are all hidden on load of a main menu based on access rights I have set locally but as soon as said...

Hi all Wondering if I could get some help here for this very bizarre issue. I have created a login form for my FE Access App with a SQL Server BE. The user passes in their SQL Login and password and its authenticated against the server. I am using their ID for table audit purposes. When the user...

Hi All I have a subform attached to a main form whose recordset is bound to a SQL Server stored procedure. I can get the sproc data to populate the subform just fine using set subformname.form.recordset = sproc_rst sproc_rst being an ADODB recordset. However the very next line, I am trying...

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

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

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

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

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

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

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

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

Hi All I am not sure if I am pushing my luck here but I have a database that holds PC info along with several other devices. In my PC table, I have a number of fields holding service tags and Manufacturer info for different brands eg dell and HP. I am trying to create a form where a user...

Very simple SELECT PCS.Device_Name, PCS.Model, PCS.Manufacturer, PCS.Serial, PCS.Reg_User, D.Device_Model, D.Device_Serial, D.Device_Type FROM PCS LEFT JOIN devices AS D ON PCS.Device_Name = D.PC_Name WHERE (((PCS.Device_Name) Like 'ARTI%' Or (PCS.Device_Name) Like 'HOHE%' Or...

Hey Is it possible to check for the following My form has 7 sets of textboxes on 7 different lines so line 1 has id1, device1, serial1, model1...up to 7th box line 2 has id2, device2, serial2, model2...up to 7th box I have some values to input into these box sets automatically but I need a way...

Good Morning All Before you ask, yes I have searched through the forum for this particular query but allow me to shed some light.I have a number of devices (printers, monitors, ID Scanners etc) that may or may not be associated with a particular PC If associated with a PC may or may not be...

Hi all I have a simple form with 3 text boxes and 2 command buttons. The buttons are for saving records entered on the form and other is to close the form on the basis of a warning message box ie if confirm you wish to close = vbyes then close the window else cancel = true 'leave window...

Bizarre heading for a topic i know but i was wondering if i could get your general ideas and thoughts. Yes I know access vba is a huge programming tool and one learns daily (trust me i know this only too well). Yes i also know requirements vary from company to company and from programmer to...

Hi All Hopefully this is not too difficult. I have a declared string dim strModel as string I am trying to run a simple SELECT statement "SELECT column_name FROM table WHERE combobox = column_name" I am trying to store the results of that query in my string but, get this, when i...

Hi All I have spent the last 2 hours trying to troubleshoot this problem. Please help. I have a form with 3 combo boxes where a user selects information they want loaded on a second form. Form A has site, builidng and facility represented by these combo boxes. When the user clicks load...