Search results

Hi all, I have a table with dates in: Start Date______End Date 01/03/05_______10/03/05 I have a form where you type in the start and end dates and when you click the search button it runs a query to display all record that have dates between those typed. The problem i have, is if i were to...

Hope someone can help with this one.... I want a form to open up and display a list of tables that exist from a pre-defined list. For example: Tables: Customers Orders Products Couriers Pre-defined list: Customers Products Businesses Contacts So as the Customers and Products tables exist...

I have my database all designed with all the queries and tables. Tables and queries are linked throughout. How important is it then to define all these relationships under Tools-->Relationships Is it really necessary?

I just converted a database into Access 97 from 2000 and its giving me an error in the code on this: Dim dbNm As Database It says the project or library is missing. How can i fix this?

I have a button on a form which activates a macro. The macro opens a query in excel, however excel displays the field headings from the table in the data as row 1. So i want to automatically delete this first row containing the field names when this query opens in excel. Any Ideas? :confused:

I have a button on a form, when clicked opens another form based on a query. If you press the Escape Key while this query is running it comes up with: "Run-Time error '2501'" The OpenForm action was canceled. Debug takes me to: DoCmd.OpenForm "frmInfoPull", acNormal So I need something...

(I had posted this in the forms section, but its more of a VBA problem) Im using a search from the sample database: http://www.access-programmers.co.uk...ead.php?t=62853 I have adapted one form so that it has 2 text boxes: txtDetails and txtCity The current code, which works, is this: If...

I have a table of addresses, and I want to be able to search about 4 fields in this table to find a building name, for example. I want to be able to do this via a form, with a text box. The user enters in the building name, clicks 'search'. Then the results could be displayed in a query or...

Is this possible to do in a query? I have the following table (for example): Field1.......Field2 1.............House, House 2.............House, Car, Car 3.............House, Tree, Car 4.............Car, Car, Car I want to count those text strings that are the same: Field1.......Field2...

Hi, I have a table structured as follows (for example): Field1----Field2 1--------House 2--------House 2--------Car 2--------Car 3--------Tree 3--------Car 4--------House 4--------Tree I want to combine the values in Field2 into one Field, for example: Field1----Field2 1--------House...

I'm trying to export a table as a (.txt .csv) file. When I click Finish on the Export wizard Im getting the following error: "The Field 'Field143' contains a start position of '32806'. The maximum start position allowed is 32767" All records in this field are empty, but it is required. Any...

Hi all, Could someone please help, as an example, i have a string in one field: 5, Woodlane, England I want some kind of query that will delete the commas so it would just be: 5 Woodland England Hope someone can help. Thanks

This seems like a really simple query, and ive tried many ways to try and get it to work, but it wont! Hopefully someone here can help. To put it simply this is what i want to do: I have two tables: Table1 1 2 3 4 5 Table2 1 2 3 4 5 6 7 8 9 10 I want to delete the contents of Table1 form...

Hi all, I'm not sure if this should just be done in a query, or VBA. I have a table called Address and a table called Incidents. I want to search through the fields Address 1, 2, 3, and 4 in the Incidents table to see if they match the fields Address 1 in the Address table. Each address in...