Search results

Try this: left([Lastname],2)

In page set-up menu the user can choose to select a specific printer and then select from a drop-down of existing printers on their network. If you are disabling the ability to use the default shortcuts, then you can add this button to your own toolbar and allow them to use it. Show them where...

Sorry... wasn't paying attention to this bit... v_cont_notes = Chr(34) & v_cont_notes & Chr(34)

Are you sure it works? If your field is defined as text then I would expect you to still need the single quotes in your statement?

Sam, You may want to check for duplicates within each of the stated tables. For each of the join fields for each of the tables, group by the primary key and count the number of instances. You will probably find that you have duplicate data in one of the tables and this would cause duplicates...

You're not very friendly or forthcoming are you!! I don't know why, but I have questioned enough... if someone asks a question in this forum it is generally because they are trying to understand your problem and help in the best way possible. You seem to want something like the following...

Ray, You could add the following module to your code and call it just before you run your export to excel code. You would call it just by adding Checkexist(Filename) as a single line command. Public Function CheckExist(FileName) If Len(Dir(FileName)) > 0 Then Kill FileName End If End...

Kriis - that is my whole point... WHY?! A table is pointless if it contains 30 instances of exactly the same record. You could add a single field with the value 30... then you don't need to copy the actual record 30 times? Can you explain why you want to do this... it doesn't make any sense...

Sorry Kriis, thought I was helping?! - Create a copy of your existing form. - Make all of the controls on the form unbound (combo boxes and text boxes) - Add a command button with the word submit. - Add some code to the on-click event of the command button that runs a sql statement that inserts...

Think that you are better off leaving the detail on a form and giving the user a submit button. They change the parts that they need to update and then click submit. The submit button just sends one record at a time to the table based on the form details. The detail stays on the form if they...

bw, I have had a quick look at this from home. You have come up with an interesting way to create a report!! Firstly, I don't think that you need to have dateserial at all. If you want to get an increment to a date just put something like the following... forms!form!strdate + 1 Your if...

I use the following: Dim dblAnythingThere As Double dblAnythingThere = DCount("[Field]", "ReportQueryName") If dblAnythingThere = 0 Then MsgBox "No records found.", vbExclamation GoTo PROC_EXIT: Else: DoCmd.OpenReport "rptReport", acViewPreview End If

If you post this as a 97 db I can look at it. J.

If you wanted to create a field called field1 with text of "hello", you would just add Field1: "hello" to your query. If you are using the query to populate a form, then you could just add an unbound text control with a default value, or even a label. If you were considering storing these...

Amy, Can I suggest something like the following: Using the customer details that you have stored in a table (?!) create a form with four controls. The first 2 fields will come from your customer table Customer Name Customer Email The next 2 will just be text boxes Subject Email Message You...

Amy, You can use practically any of the Office suite including outlook directly from Access code (VBA and macros). Nearly (if not all) of the functionality is available. I for instance send up to 1000 individual winzipped password-protected reports directly from an Access Database to multiple...

I have been to... Australia, New Zealand, Rarotonga, Malaysia, Singapore, Thailand, England, Scotland, Ireland, Wales, France, Spain, Portugal, Germany, Austria, Switzerland, Belgium, Andorra, Egypt, Italy, Greece, Turkey, USA, Canada, Mexico, Sweden, Denmark, Norway, Holland, Czech Republic...

Here is a short description of what I would do. Copy your existing db as a back-up before you make any changes. Zip it and leave it in case you make a mistake. Copy the back-up table to your current database and call it by a different name. You can import it to your current db, or you can...

Odun, If you understand the vb that your form creates for controls, combo boxes, etc. Then you could search through the code for the existence of the name. Or step through the opening sequence of your db until you find the problem. Another alternative is to create a new db and only copy...

Main-man, It sounds like you haven't used db's much. This should be relatively simple. 1. You could do an "unmatched" query through the wizard, and then change this to an update query. This allows you to select all the records from one table which don't exist in another. 2. Alternately...