Search results

Ever come to a point where you can either, scrap your original idea and do something a different way that is more simple and ultimately better? My form started as just a front page to look at my data but then I was told my boss wanted to be able to edit all the info so i wabted to export the...

Hello, I have a CMD button which I want to use to create a temporary table with the records from selected results in a list box but I am having trouble creating my table using the Creat table funtion as shown below Private Sub CMDedit_details_Click() CurrentProject.Connection.Execute "CREATE...

Ah well, you see that is what I want. I want to assign each company with a territory, but I have two territory's for each postcode, thus one postcode can have many territory's, one territory can have many postcodes, to solve the I designed a territory_lookup table to hold just the id of the...

I don't know how I've managed to do it, but I've messed up my SELECT query which is used by an append query. I have two queries. The first is a simple query that contains the Pk from my main table [prospects] and a split_code query to take the first one or two digits of a postcode. code...

Change your fuel rebate query: Expr2: [Total]*([Fuel Rebate on Road%]/100)

I must admit to only having ever designed three databases, the one I'm working on now is collosal, many different tables with postcode territory's, search queries, link tables and filters. None of this could be done without first making sure you have a stable platorm (for want of a better...

I don't know of any programmer I know who jumps right into biulding a database without planning first. For me everything has to be done on paper, i agree with Lee. You have to talk to the user as much as possible, only when you have found the entities you require, what the database will be...

thanks..... again!

can u convert a link table into a normal table?

ok, it works now!! :D thanks a lot, dcx693!!!

It tells me that the macro does not exist or cannot be found. When inputting the code I have put. Private Sub Command27_Click() = "Delete * FROM prospects WHERE id= '" & Me.Results & "';" End Sub Does this look right?

Howdy, I have a list box containing a query result, from a search text query in an address table. How do you delete the record from the source table via a delete button in the form using the selected address in the list box?

Thankx Cheers IMO, you're a good lad

Is it possible to have a text box that has two different sources? i.e, if the value in one is null the other will show in the same box?