Search results for query: *

Ok I've been working on a form for some time now and it works perfectly (famous last words!). I now need to copy my form and replace one piece of code throught. I need to change EVERY reference in my form to TblMod3 to another table, ie TblMod2, and then copy the form again replacing TblMod3...

When my form opens it is in full screen (docmd.Maximize) but when I view a report it re-sizes in the bacground of the report - so when I close the report view I have a re-sized form. Solo7 [thumbsup2]

I am using SQL to set the record source of a report based on 2 parameters chosen by the user. My user selects a table to look in, and then specifies the dates to search between to perform the query. My report works ok for a specified table but as soon as I try and selct a different table the...

I have an ADODB Recordset which I want to export to a CSV file. However i need to play around with some of the fields before export, ie change the Name field to 2 fields consisting of First Name and Surname - So John Doe in my DataBase will be 2 columns in an excel CSV file. My theory is to...

I am using the following code sucessfully to retun the number of records in a SQL statement. Dim StrSql As String Dim rst As ADODB.Recordset Set rst = New ADODB.Recordset rst.ActiveConnection = CurrentProject.Connection rst.CursorType = adOpenStatic '---------- Get count for Module 1 waiting...

I'm using a DTPicker control in a form. The date is set to display a Custom format set to dd MMM yyyy - and this works fine every time I select a date the correct date is shown in the box. However when I reference the DTPicker.value I always get the American date format ie MM dd yyyy - so when...

I am using a VB front end to get the address of a spreadsheet, and the worksheets in the spreadsheet. I'm then putting the values from a selected worksheet into a Access table for report producing. I have a persistant error which I think may be related to my opening and closing the...

I am importing a spreadsheet useing the following code :- DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "TblTemp", StrXlsAddress, True, StrXlsSheet where StrXlsAddress is a string holding the address of the spreadsheet, and StrXlsSheet is the name of a specific worksheet...

I am using VB6 drag and drop to get a spreadsheet's location. How can I obtain the name and number of sheets within a spreadsheet ?? Solo7 [thumbsup2]

I want my users to import several spreadsheets. To do this I can code a module to import their spreadsheets, but I want them to drag and drop their shreadsheets onto a 'Form' which will then pass the 'path' to my module for automatic importing. So I can eliminate errors in the 'Path'...

I have a recordset to which i have assigned a sql statement. This is in a loop and the resultant records returned will be either one record or no records. I am trying to use the <recordset>.RecordCount property of the recordset to 'catch' the records with a value - but for every pass of the...

I have 2 queries both of which return correct results. First query lists all students, second query list students who are in a specific class. How can I merge these two queries so that query 3 displays all students who are not assigned to the specific class? Of course if there is a one query...

I have a list of several hundred names and associated dates in an Excel Spreadsheet. The date is in the format of YYYY-MM-DD. I need to get this data into a .csv file, which should be straight forward enough. However when I save as a .csv the date is in the Date-Time code (ie, 32844 =...

I have a SQL statement running in a loop which I know will only return 1 text value OR it will return no value as it doesn't exist, a NULL value. What's the best way to handle this? Will I need to build a Recordset for this single value return? solo7 [thumbsup2]

My code (below) is working fine, and gives me the values I need; 'Loop through the recordset ' Do While not rsPeriods.EOF 'Write the HTML to display the current record in the recordset Response.Write ("<br>") Response.Write (rsPeriods("Fld_Periods")) 'Move to the next record in the...

I have the following code which works fine and does exactly as I want it to. However this code applies to one command button and there are 14 - I would like to cut down on the bloat and try to get this into a loop. The code below works for all of my buttons Command00 to Command13 and list00...

I have my SQL string and I'm trying to assign it to a listbox to display what I want. My SQL string picks up user selected variables and I want it to pass the results to a list box, refreshing each time the user selection changes with an 'onclick' event I have tried the ListRowSource property...

I need to find an example of using Data Access Pages that picks up 2 values, 1 from a combo box and one from a list box - and then passes those chosen values to another list box as part of it's source query - or data source or what ever DAP list boxes use - via the clicking of a toggle button. I...

We have 250+ pc on our school site. We've upgraded to WinXP (service pack 2) and upgraded the printers to have integrated network cards. We have allocated each room to have it's own 'Organisational Group', and we are trying to script the printers to be installed on start up (log on). We've...

Can I use a loop to reference an object? I have 10 list boxes list0 - list9 and I want to perform actions on all of them. Instead of referencing them individually can I reference then from inside a loop? ie For IntN=0 To 9 list & IntN.Visible=False Next IntN Obviously the above example does...