Search results for query: *

Hi there, I've used the code below to assign control sources to the fields, I have similar code to assign labels, but when I run the report, only the first records appears, the source query has at least 10 records. Can anyone tell me what I'm doing incorrectly? Thanks Private Sub...

Hi there, I have a print button on a form that I'd like to use to print out the linked subform after "filteredbyselection" has been used. I can print the whole form using:- DoCmd.SelectObject acForm, [frm], True I assume I have to make the filtered form the SelectObject, but cannot work out...

Hi there, I have a main form linked to a subform by a Unique ID field. I have a command button on the main form that uses "acCmdFilterBySelection" to filter by the selected field. When this button is clicked I'd like the subform to be filtered by this same field. Does anyone know how I can...

I have a form with fields named "Product Category" and "Geography" amongst others. There is a FiletrBySelection command button sot he form can filter by either of these 2 fields. I also have a subform which is linked parent/child by the "Geography" field - this essentially filters the subform...

Hi there, I'm trying to find a list of the commands available under DoCmnd.Domenuitems. Help gives a few but not the full list. It says for the full list look at the command arguement list in previous versions of Access. I'm using Access 2002. Can anyone help? Thanks

Hi there, I'm pulling my hair out...I have a parent form with 2 child subforms (bound to different tables. I have a cmd button on the parent form that copies specific records from one subform to the other using a DoCmd.RunSQL "INSERT INTO line. this works well the values are inserted into the...

Hi there, I have a table that I'd like to archive, in order to do so I'm renaming it and adding appending the month in which it applies to. The code below adds the current month, but I'd like to add 2 months previous, e.g Format(Date, "MMM" - 2) but I can't work out the code. DoCmd.Rename...

Hi there...this is a little longwinded but please bear with me. I have created a Revenue Forecasting database. Functionality should allow users to input new customer order details and secondly to be able to leaf through records to find particular orders. A main form contains generic customer...

Hi there, I receive a monthly flat file xls - formatted as below:- Customer Time Value A Q42005 £1000 A Q22006 £2000 B Q12006 £500 B Q42006 £3000 I have a crosstab query which converts this into a spreadsheet format as below. Customer...

When I open my database I can update the forms no problem. But when I open the database and search for a particular record using the code below:- Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[ID] = " & Str(Nz(Me![Opp_ID_Search], 0)) If Not rs.EOF Then Me.Bookmark =...

I've gone into a database that I administer for the first time in a week or so, on opening I now get a message saying Access has detected a corruption in this file. I can get into the database but cannot run queries etc, when I click on anything I get the corrupt message. The all data is held...

Hi There, I have a Year input combo box on a form. The options to choose are 05, 06, 07, 08 etc. I'd liek to use this value in the caption of another control in a subform. I'm part of the way there, but instead of retruning the 2 digit figure from the combobox, only a single digit is returned...

Hi there, Using "DoCmd.TransferSpreadsheet acExport, 8" I'm trying to export a query to an excel template. The query is based on 2 others. With regard to one of the queries, the field names are not static as they are the result of a crosstab query based on user inputs so to include all the...

Hi there, I have reports that are to delivered to a specifie folder. They appear with no file extension, so I have to add ".txt" to each one. Every month the filenames are differnt. I'm trying to come up with a way of adding txt to the end of every file in the folder so I can import them. I...

I use the following code for a find record commandbutton on one a form. I would like a message box to appear if the requested record is not found. Can anyone help me with the addition I need to make to this:- Private Sub Find_Click() ' Find the record that matches the control. Dim rs As...

I have a table with a filed named "LC". All records have 1 of 4 values for "LC": - for example "Bob", "bill", "ben" or "baz". I query this table using a value returned from a combo box in a form. The values in the combo box are "Bob", "bill", "ben" or "baz". To query all records...

I have a user input form which is used by Salesmen to input details of contracts they have sold. As a simple example the text boxes/comboboxes are:- Start Date (year) - combo Start Date (Quarter) - Combo Q1 Revenue - textbox Q2 Revenue - textbox Q3 Revenue - textbox Q5 Revenue - textbox Q6...

I'm using the following code to export a query to an excel template. The code works, but my problem is that it adds a new sheet to the template titeld with the query name rather than use the sheet that I have preformatted. Sub Command5_Click() DoCmd.SetWarnings False DoCmd.TransferSpreadsheet...

I have a form and a subform linked with a parent/child relationship on the ID field. When I open the main form all is well, I can toggle through the records and the subform records change accordingly. However... When I update some of the fields in the subform (which consists of a combobox and...

Hi, I have a 'Delete' command button on a form which I want to use to transfer a record to another table and then delete it from the original table. The From contains a subform though, so I can delete the data from the record that is stored in the parent form using DoCmd.RunSQL "INSERT...