Search results

In the format field of the Autonumber properties. Set this format to the number you want to start at. i.e. \10 or \20 or \1000

References. I know that reference have been mentioned but hpw about this 1. Microsift DAO 2.5/3.51 Compatability Library. This can be found in the following place (possibly) C:\Program Files\Common Files\Microsoft Shared\DAO\DAO2535.TLB I will also attach it if it is not there. Also. I had...

Why not just use this. Docmd.setwarning false docmd.openquery "DELETEQUERYNAME" YOUR IMPORT ROUTINE docmd.setwarnings true

Try this......... This little tool lets you compact and repair a lot of corrupted databases. There has only been 1 db that I have not been able to use this on. The Jetcu4 file is for Access 2000. might work for 2003.

This is the code that I am using. Like I said, it works in Win 98 & 2000, so I don't want to change it too much. Public Sub EmailSociety(ToAddress As String, FromAddress As String, Subject As String, BodyText As String) 'Package these files. Dim strFilename As String...

I am trying to send an email from and Access Form through Lotus Notes. This works without any problem on Windows 98 & Windows 2000, but when I try it on Windows XP, I get the following error message. This Email could not be sent. Please contact your System Administrator with the following...

Just add a command button.... Add a command button on the subform to open up the selected record.

Here is the example form that I mentioned Just look at the attachment.

Yes it is possible - BUT....... there is a fair bit of meesing about. I have done a 10 page report in 1 using sub-reports and page breaks. Sorry, but I don't have the db anymore as it was no longer required.

Instead of a Subform.... Use a Text box to create your query upon clicking the button. I will try and find and example of this for you. Just need to remember which of the db's I support uses it.

I have some examples of drop-down boxes. I have uploaded them. Hope they help.

That's what I thought. It was worth asking though. Thanks anyway.

I have been asked to look at a .mde database but the user cannot find the .mdb file. Is there any way of unlocking this file???????????

Did that work? I sent the db back to you this morning. Did it work?

Look at the query there will be a prompt asking for the number. Do you need to put the number in?

Check your Private Messages. Email address is in there.

Ok. To start, run queries to put the information into 1 table. In this part, you could break down the fault code into 2 fields using a Left function. Then run the query on this 1 table to get the totals using Sum on the BOG and TRD fields. Then use this query to run the report and in the...

How many tables is your original query looking at? :confused:

This is for ORACLE but may help. We use this on one of our systems. Look at the attached file. Hold down the shift key when going in as the AUTOEXEC is still active . we use the Oracle ODBC Drivers, so it may be different for SQL Server.

Try this..... You will possibly need to run a query within a query. Query 1 to get the Sum of the Qty Delivered. Query 2. Using Query 1 and the original tables, you will then be able to use the following :- QuantityRemaining: [Quantity]-[SumOfQtyDelivered] Hope this helps.