Search results

I copied and pasted the form name but as I said it works as a macro. Just realised that I should have put this on the VBA area- sorry :o Gordon

I have a group form with extra buttons to print, review a report or close the form. If I use a Macro then I can close the form. I converted the macro to code and I get the error message: A problem occured while Microsoft Access was communicating with the OLE server or ActiveX Control *The...

I have a report which is filtered using the following criteria on a query <=[Deliverables upto T0+ date] How can I get the user input displayed on the form? Cheers Gordon

Hi, I have an option group that selects what is printed on a report. Is there anyway that the user can save their options to use at a later date. Cheers Gordon

Hi, When Excel is inported access sets the columns data type to what is in the first row of the column. If the data type changes then it will cause your error and create the error tables. Tips Do not have an empty first row. Have only 1 row as headings. Do not use merged...

Thank you for that. It was very interseting. Gordon

Hi, I have been tasked to create a database that will be accessed through a dial-up connection to our server. What I want to know is which is faster 1 Using a seperate table for dropdowns or 2 Using the lookup facility of a table. cheers Gordon :confused:

Ah, so thats what this is for

Hi Tim, Thanks for that but I solved the problem. It was the Query names that had the effect. The Queries that worked were normal but those that did not had hyphens in them i.e. QryCDFConfigBaseline Worked QryChangeList-2-P9B Didn't. Thanks for your time it was useful and...

Hi Tim, Sorry for being thick but5 I do not really understand what you mean. Yes, it was copied and modified from MS Help. I am using 2000. Original code: Global rstSuppliers As ADODB.Recordset Sub MakeRW() DoCmd.OpenForm "Suppliers" Set rstSuppliers = New ADODB.Recordset...

Hi again, I now have the ability to select a query and have a form open on that record set. The problem is that some of the queries generate the error message : Invalid SQL statement; expected 'DELETE',INSERT','PROCEDURE','SELECT' or 'UPDATE' Code is Private Sub Combo0_Click() sQuery =...

Bad Design I agree, and not mine but it is too large to change and I have been given a short time to try to solve a problem. The original designer is still with use but too busy. Thanks for your help. Gordon

Just found your thread and it seems to do what I want BUT I do not understand it. I want to list all queries in my database into a combobox then select one to be the record sourse for a form. Tried the following but got the 'Object does not support this property of method' error Private Sub...

Thanks for that. Cheers Gordon

hi, I would think one way of sorting by ';' is to record a macro in word and either use it in word or copy into access and adjust the code to match. I would create a new word document with button to do this. It is reasonably easy. Gordon

Hi, I have a requirement to filter some queries periodically on the date field. What I want to do is create a form that lets you choose which query to use and filter and not create alot of single forms. The filter will be only be applied whilst the form is open. Cheers Gordon

Hi, I am trying to allow users to filter a report using the 'Filter Attribute' [Feild to Filter]<= [Criteria] This does not work. I can use the '=' on its own but I really want to show all the records below the selected number. :confused: Cheers Gordon

I have a sub form to which I want to apply filter buttons. I have used the wizard to set these up. The problem I have is that when I try to filter the SubForm the MainForm also filters. The forms are based on tables and not queries. Cheers Gordon

Thanks for the help. Am getting to grips with the SELECT function but slowly TA Gordon

Hi, I have one real puzzler for you, (well it is for me) I have a date field on a query that I sort using the following criteria: Like "*02/2005" This works. When I use: Like "*03/2005" it does not work. There are data items related to this date. If I use the <=Date() it finds...