Search results for query: *

Hi, I have written some code so that the data from my Access form is transfered into a Word document which then prints. However, one of my text boxes on the form is formatted to only contain upper case but when this is transfered to the Word document it reverts back to the users original input...

Hi Sameal, Thanks for your reply - I have tried your code but I'm being a bit thick here. TableID? What do you mean by TableID do you mean the primary key (e.g. EnquiryID) or do you mean just 'TableID' without substitution? At the moment when I run the code I get the error message: 'Run...

Sameal Thanks for replying. Do you mean have a messagebox inside an 'If' statement as I have above (original message)? If so, how do I then do the combo box addition?? This is the part that I am confused on. Thanks again Confused Keza

Hi, I'm not sure if I can explain this properly or if it can be done but I'll give it a go. I have a combo box with a list based on a Query. I also want the user to add new names if they so wish but if they do so, I want a message box to pop up asking if they wish to add this name to the list...

Thank you Jim, it seems that the brackets were causing a problem which has now been resolved. Keza PS Thanks James for also replying!

Hi I am trying to use a variable (= CC) in the following code in an Access Report, so that I can loop through 25 different CC's (only showing 3 here). However, it does not seem to like it. Could somebody please take a look at my code and see what I am doing wrong - maybe it can't be done but...

Hi I want to be able to create a combo box list using the data in my table but only extracting unique values. Would it be better if I based the combo box on a query? If so, how do I extract only the unique values so that I don't have a list of repeated values?? Please help!! Keza

Hi, I have just created an Access Report using the wizard. However, it has not given me enough room for my headers - when you look at print preview the headers go across 2½ pages which is fine except it will not let me add an extra 3 headings on the end. How can I extend the screen width to...

Hi, Cheers for your suggestion which I tried but it didn't actually add them together it just concatenates them. Does this mean I have to admit defeat. All I want to do is have a form which can perform calculations like a calculator!! Keza

I have created a new form, inserted 4 Unbound text boxes. In the 4th box I have inserted in the control source: =Sum([Text1]+[Text2]+[Text3]) Why won't the above work??? Is it because they are unbound boxes?? Please help! KG

Not sure if the following is possible: I would like the 'User' of the database (who cannot get into the design view) to be able to calculate a sum in an existing text box of a form e.g. 2 + 2 (Access automatically produces the answer) However, on some occasions these boxes may already contain...

Hi, I have written some code that inserts into the main table new data (Supplier's name) that is not in the combo box list (notinlist event). e.g: Set dbsInvoice = CurrentDb() Set rstTable = dbsInvoice.OpenRecordset("Supplier Table") rstTable.AddNew...

I have just asked about adding values together in a form in a text box. I tried out the reply of '=SUM' in the control source which would have worked but I had forgotten that at times I already have a total in that text box using the control source of a table (I hope that makes sense to...

I have recently converted an Excel spreadsheet into a more user friendly Access database. One of the things you could do in excel was to have a running total in a cell i.e. you could do the actual calculation in the cell - '=SUM(2345 + 2689)'. I would like to have a similar facility in my...