Search results

Hi I've got an open excel spreadsheet with a user form. The user form has a button on it that will open a browser dialog which allows me to select an access database. Once I have selected the database the full file path and name of the selected database must populate a text box on the user form...

Hi I'm trying to add records to the asset_details table. Basically for every record that exists for a Switch (SWIT) currently I want to create a corresponding record for the parent asset, a switch site (SWSI). The primary key on the asset_details table is the Asset_ID so I would not expect the...

Hi The following query works okay in SQL Query Analyzer but when I try to paste it into the SQL view of an Access query I get a "Join not supported" error. I dont think it like the left outer join. Actually I have aseries of left outers in the full query but I've abridged it. SELECT...

Hi I use my laptop to retrieve data from a dB over our network. This Access id constantly being updated and I want to save the latest copy to my laptop before I leave the office. I am only interested in data retrieval and dont need anything fancy like a wirless VPN. I simply want to save a...

Gotta field in a form called txtWorkPack with a default value of ="*" gotta report that takes a big sql string that includes txtWorkPack thus str3 = Forms![NP_Work_Pack_Filter].[txtWorkPack ] then: SQL = "SELECT work_tasks.Work_Task_No, "note from luigi "heavily edited" &...

Hi I'm trying to send a string from a form to an SQL in a report. This one works: If cmbLocation.Enabled = False Then Asset_Loc = "Like '*'" Else Asset_Loc = "= '" & cmbLocation & "'" End If but not this one: If cmbLocation.Enabled = False Then...

I need to calculate the end date of a course of 156 days duration and adjust for holidays if they occur during the course. There may be one or two X 1 week holidays (5 April to 12 April and 20 September to 27 September) between the start date and end date depending on the start date. Is...

Can I use "TransferSpreadsheet" and get some control over what info to put where in the spreadsheet or do I need to cycle through a recordset?

I have a recordset which I’m using a Do Loop on to extract records for each student and put into a spreadsheet. Problem is The student Id is in one table and the other values are in the “many” table joined on Student Id. My recordset is: Set rstStudents1 = dbs.OpenRecordset("SELECT...