Search results

I've got some VBA code to build an Excel file on the fly and generate with data from my access tables. The code breaks when I try to export a memo field which is too long (haven't had time to character count yet - I'm thinking its over 256. I've made the data small to test and it works fine...

I've been googling like mad. There's plenty of info on creating charts in access reports ... but here's what I need to do. 1 Excel Workbook 1 Worksheet 1 table of data I already have this worksheet opened via other VBA in my Access database (i've been exporting a query to the excel file and...

I'm exporting the contents of a query to an excel file, opening the file and attempting to make some basic modifications to it. Then saving and closing the file. I'm have INTERMITTENT issues - sometimes the export and modifications works fine without any errors. Sometimes I get runtime error...

I have a query which pulls the following fields from 3 related tables: Stat_Date StatType_Title Stat_Data The number of records this query will return will ALWAYS be 20 records. I need to export this data to excel, specifically into a cell range as follows: Stat_Date as the X axis (from...

I'd like to populate a combo with a list of all the form names in my database. Can anyone help? TIA

I've knocked together the code below and am at the point where I am getting no error messages but no value is being copied between the two workbooks/sheets. The destination sheet is in the same workbook that the code is being run from - so I am opening another file and copying the data from...

I have a continuous form which will only ever have 3 records. I have a command button which executes some code that changes the values of a specific field in all 3 records. I need the form to update to show the correct values after this change. However ... I can't close/reopen the entire...

Wasn't sure whether to post this here or in the forms cat. As it involves code, I chose here. I'm trying to simulate a progress bar within a form using a textfield. I've found the following code on t'interweb but cannot get it to work. When I click the command button to start the progress bar...

My SQL so far: SELECT s1_quotes.* FROM s1_quotes WHERE (SELECT [Services_Desktop]![service_id] FROM Services_Desktop WHERE [s1_quotes]![description] LIKE "*" & [Services_Desktop]![service_id] & "*"); s1_quotes is a table with a "description" field which is memo format as it contains too...

I have a continuous form based on a query. The recordset returned will always be 3 records - but as far as I can see this shouldn't be relevant. Therefore, I'd expect the form (in form view) to display the form header, the 3 records and the form footer. I've disabled the ability to add new...

I need some MS Access VBA code which will allow me to delete all rows from a specific workbook (which contains a single worksheet) EXCEPT Row 1 which contains the column header. There is actually only 1 column of data (which gets populated with rows and rows of reference numbers) ... so this...

Here's the scenario ... I have a column of data (no of rows will change) and I need to know how many records contain a specific phrase within the cell value. The whole cell value will not match the specific phrase but it will contain it. e.g. How many cells in Column E contain the phrase...

I have a column of dates in the following UK format: 19/07/2007 15:00:00 I'm trying to calculate, on the fly, the number of cells with a date over 56 days ago. This is the closest I can logically work out myself: =SUMPRODUCT(--(p_Network!$D$2:$D$50000<DATEVALUE(Today()-56))) The cell...

Is this possible? I have a query which gives 5 fields. I have an excel file formatted with a specific layout and 5 empty cells for the query results. Is there any VBA I can use to copy the query data to those specific cells on the fly??? v: Office 03

I'm using the bit of code below to combine the first worksheet of every workbook in a specific directory into a single workbook with multiple worksheets. This works OK so far, the only thing I'd like to add is to Save the resulting xls file into either the same directory or another specific...

I need to use square brackets as part of the criteria in a LIKE SQL statement. The criteria is: [ABC123][SR] ie, find all records which have that as part of a longer text string. How can I amend the SQL statement below to "escape" the square brackets and treat them as part of the string...

Here is my table structure: tbl_Questions ---------------- Question_ID (autonumber) Topic_ID (lookup) Question_Title Question_Number (and a few other irrelevant fields) What I'd like to do is populate a listbox with all records from tbl_Questions which have a certain Topic_ID, ordered by...

tbl_Topics * Topic_ID (autonumber) * Topic_Name (text) frm_Add1 has a simple 'Topic Name' field, which is entered and then a record created in tbl_Topics. I have a little bit of VBA which validates and enters the record, closes frm_Add1 and opens frm_Add2. On frm_Add2 I will be entering data...

I'm looking for some code which will show a certain form button IF SQL criteria is met. Basically, I have user data in a table with one field being 'Admin'. If the user which has logged in to the database has a 'Yes' value in the Admin field then I want the button to show. Otherwise it should...

Not sure if this is a 'query' query or a VBA query to be honest. I am making a quiz/assessment system. I am at the stage whereby my database can take people through a number of assessments and record their answers. I now need to work out how to check their answers against the correct answers...