Search results

You don't need to know SQL. If you go back to Query Design View, add all the fields you want to bring back in your query, then in the criteria boxes underneath each field, type the criteria you need. Have a look at this attachment, hopefully it will make it a bit clearer.

You can write a query which will return any records with the next check date within the next 15 days i.e. SELECT TblChecks.Name, TblChecks.LastCheckDate, TblChecks.NextCheckDate FROM TblChecks WHERE (((TblChecks.NextCheck)<=DateAdd("d",15,Date())));

Can you post a sample of your database? Would it work if you were to have the main form linked to your table and not use subforms. Just put the controls you want straight onto your main form?

Where does the combobox get the list of names from? Can you post your database and I'll try and help?

What window are you trying to switch to? Why do you want to switch windows?

Take a look at the attachment I posted here. You will need to replace client with town/suburb and the phone numbers etc with the state and postcodes but the principle is the same. Hope it helps. :)

In your table, set the properties of that column to general number, not fixed.

I've attached a sample showing how you can use command buttons to select the page on a tab control. As for making changes to other pages in design view, there may be a better way, but if you set up the pages how you want them while you've still got the tabs showing so you can navigate between...

I've attached a sample which might give you what you need. It's fairly basic and might need changing depending on how you are storing the contact details. If this doesn't help, if you can post your database I'll have another go.

Can you post your database and I'll try and take a look at it?

I don't know but have a look at this thread. Screen Resolution

I'm not 100% sure but I think as you're using this in a query you have to include the value if null in the Nz function. i.e. Nz([mk_tblBreakdowns].[Breakdowns],0)

I think what you want is probably something like this. tblStocks contains your list of stocks with stock_ID as your primary key, each only entered once though. tblDiv_Schedule contains the records of the dates and values of the stocks, with stock_ID as a foreign key (related to stock_ID in...

Can't you just delete the damaged record?

Can you give an example of the data you want in the tables? Is there going to be only one entry in the div_schedule table for each entry in the stocks table and vice versa? Where do the dates and dividend value come from for the div_schedule table?

This is a problem I've also experienced when trying to import to an existing table. I've got around it in the past by importing to a new table, then running an append query to put the data into my existing table.

For those of you not fortunate enough to have come across chavs, this site gives a bit of a description. http://www.rsod.co.uk/rsod/cargo/Townies.htm

This might not appeal to those of you not in the uk, but for anyone who has encountered scallies/chavs or whatever you want to call them, this may amuse you. http://www.cecimoz.pwp.blueyonder.co.uk/Chavs.htm

Perfect. Thanks Ken.

I have a form (Form1) with two combo boxes (Combo1 and Combo2). Both have their Row Sources as queries based on the same reference table (tbl1). For ease, I'll say the table has two columns as below. Col1 Col2 1 A 2 B 3 B 4 A 5 B The first combo box has a row...