Search results

Hello, I would like to change the colour of the back ground of the cell (field name) when data is wrong on a report. I have the following code which worked before on a form but seems to be a problem in a report: If Me.SCHED_DATE <> Me.Committed Then Me.SCHED_DATE.BackColor = 255...

I have written this function to remove all "-" or spaces in a string and it seems to work fine. But as I go record by record and remove them it don't seem to store them in the table :( here is my code: Private Sub Remove_hyphens_Click() On Error GoTo Err_Remove_hyphens_Click Set db =...

Doe's anybody know of a way to add to the top bar special characters e.g. Ű ő æ å ø I have a lot of addresses to enter that are from Germany Norway etc so I need to be able to enter these extra letters in there address line. Thank you in advance Mike

I have the formula: Format(DateAdd('m',-6,Now()),"mm/yy") in my query but I want it to show six months back to now but it only shows the month from current -6 months :( how can I get it to show the other five months in between? Kind regards Mike

Hello, I want Access to prompt for Attachments when I send an email. I currently use the line: myemail.Attachments.Add "c:\progra~1\adobe\acroba~1.0\PDFOut~1\Custom~1.pdf", , , "Custom~1.pdf" But now we are going to place customer quotes in folders and I want to be prompted to save this to...

I have a problem, I have a quotations database I have two tables one for customer details with the quote number and one to hold all the part numbers for that quote. Now I what to generate a query that will show all the quotes for that area e.g. UK. Problem is it show all the quotes but with...

Hello, does anybody know how to append an exported excel file from access 2k? I have the code: DoCmd.OutputTo acOutputQuery, "QuotationEmail", acFormatXLS, "QuotesUpdate.xls" I do this on every quotation completed so you can see what happens, it overights the last one done and I end up...

I have a problem with a continous form :( I have a combo box that I can select items after I select one. I would like it to drop down one line so I can select another line and so on, keeping my main input line at the top of the screen and the previously selected items scrolling down under...

How can I add a new record on a subform? I use the code: Forms!Customer!NotesQuery!Customer = Forms!Customer!NAME but this just overrights the customer field on the notesQuery form Thank you in advance Mike

I am having problems with my code to send emails, the code works fine but I want to be able to edit the email before it sends but I cannot see how to do it :( here is a copy of my code: 'DoCmd.Save acForm, "Quotation" DoCmd.OpenReport "QuotationEmail", acNormal, "", "

I seem to have made a big mistake when designing my database, I have a stock file which I set an index on which was autonumber but when I updated the stock from an excel import the key field used to reference the table updated via auto number. I should of used partnum :( So now I altered the...

I have imported data to a new table now I want to export all the records to another table with different field names. How can I do this in code without having to design a form that will copy all records over using a query? Thank you very much Mike

Can anyone tell me a way to trace a varible while I use Access? this database is so big and I just can't see where the value to this field is being input from :( Kind regards Mike

Using the DoCmd.OpenQuery command how can I now select each record in turn and set the value of [NewCustomer] to True? Kind regards Mike

Can anyone help me, I want to copy a set of records and put it in a query and before that I want to set a status copied bit to true. Kind regards Mike

I have a problem. I have a main form for a work order database then a sub form with trays that are filled and going out to outworkers. I want to close the job when all the trays have a complete date but I do not know how to select the next record on the subform to check until end of records...

I have a problem, hope someone can help. I have the following code: If Forms![stores].RecordCount = 0 Then MsgBox "There are no Jobs to complete yet", vbOKOnly Else If Me!Printme = "PRINTED" Then Me!Box38.BackColor = 255 ' Otherwise, display as a green...

Hi, I want to click a button on my main form and for it to create as many records as there are tray numbers. The main form is called WorkOrderDetails and the sub form is TrayDetails1 The code I have tried using is:Dim x As Integer x = 0 For x = 0 To...

Hello, I want to be able to add an item if it's not in my combo list, but if I try this it comes up with a message saying I have to select one from the list :((( is there a way I can just enter something if it's not in the list? Thank you Mike

I am having a hard time with datatypes :( all I want to do is store a subtotal value from a form textbox and store in in my table for history reference. I use the code: Me.subtotal2 = Me.Total Total is the name of the textbox on the form and subtotal2 is a field in my products table set to...