Search results

I have a report with an unbound text box that refers to a combobox on a form. However when I look at the report via print preview it shows the position of the text selected in the combobox. For example if the combobox was a list of the alphabet and I chose "D" the text box would say "4" instead...

Here is my code. I am getting a run time error that says "single row update/delete affected mroe than one row of a linked table. Unique index contains duplicate values" Error is in red. Any suggestions? Private Sub Command108_Click() Dim Cname As String Dim Catname As String Dim Cnum As...

I am trying to make a user friendly interface where a lot of updating of reports occurs. I have a form where a user can choose a customer name (eg. John Doe), type in a date (eg. 1/1/2011), click the command button and what I want to happen is that a textbox in the report "John Doe" with update...

Access to Excel Code Errors Hello everyone. I've been reviewing threads and this one seems to be the one that most relates to my problem, but I couldn't exactly find the answer. I'm exporting a query I create in VB to Excel and then wish to format it. I first did the formatting in excel to make...

I'm trying to create a query. The only part that is giving me trouble is the Parameter value. Even though the parameter value is defined (I think) the "enter parameter value" still pops up. I don't want that box to pop up and I want the query to show the results for "objname." Any suggestions?

Hello, I'm going to try to be as detailed as possible without being confusing! I am using the latest version of Access. What I am trying to do is create a form that lists all the reports that I have made. When the user selects the report he wants, it previews the report. Then there will be...

I have a Master Table that is linked in from SQL. The Datatype of the column I am having trouble with in SQL is Text. I link the table into Access and when I look up the datatype of the troublesome column in Access, it is Memo (some fields go up to almost 800 char). I then make a query using...

Hello and thank you in advance. I have search the forum and have found people with similar issues, but I couldn't find an answer that could help me.. I'm sorry if I'm reposting an already asked question. I am attempting to create a pricing report. I have different products and different prices...