Search results

Of course I figured it out right after posting and its an obvious answer. For future reference: =[Forms]![Document Creation_Default].[Combo7].Text

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...

If I make all the text boxes on all the reports ="Effective: " & Format(Forms!FormName.Text126, "mmmm dd"", ""yyyy") then ALL of them will have the same date. If I do it that way, it doesn't matter if they select John or Jane, the date will be the date is Text126 at the current time. And, when I...

That would work, yes and that is what I did have, however the date will be different for every customer. so the effective date for John is 1/1/2011 but Jane's is 6/1/2011.

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...

I would like to do something very similar as you but I am having a difficult time.. In a form I have a textbox where a user will put a date (January 1, 2011). The user will also choose a report. After they click the command button what I want access to do is find that report, find the unbound...

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...

Right after I posted it I figured it out.. I was missing the single quotes. But thank you!

Hi everyone, I'm also doing a Dlookup in vba and I was getting this same error. However, the criteria has a hyphen in the name. For example if I was looking up ColumnName = "toy-r-us", it is giving me The expression you entered as a query parameter produced this error: 'toys'. Here is my code...

Sorry for not responding but I have been off of work until now. But it worked! Thank you so much!

no... because now it reads it as "Where dbo_qry_MasterPriceTable.name =ogjnameORDER BY dbo_qry.......

Now what it is doing is that the "Enter Parameter Value" box still displays, the objname is showing up as the label or title, I guess? I'm not sure what you would call it, it's the text that is above the box that you are suppose to type in the paramenter value. It's still requiring me to type in...

Its a combo box in a form. The combo displays the names and then it finds the name chosen in the MasterPriceTable and creates a query just using the names chosen (that's what it's suppose to do.) and it is defined.. when I added the message box it came up with the right name, it just doesn't...

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?

nvm! figured it out. for future reference: Private Sub Command93_Click() Dim rn As String Dim vFilePath As String Dim objn As String Me.Combo7.SetFocus rn = Me.Combo7.Text & ".pdf" objn = Me.Combo7.Text vFilePath = "S:\Reports\Pricing\" If Me.Check72 = True Then DoCmd.OutputTo...

Hi, I have a similar problem but I don't think its as complicated. I have checkboxes and when the checkbox is checked and a command button is pressed, I want it to perform an action. For example, I used a combo box so the user can pick the report. The report is displayed in a subform. when a...

Check that part off my list! Thank you!

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...

How would I go about doing that? And my report names are already descriptive.. They are names of customers