Recent content by bstice

I figured it out. Here you go. Private Sub Command22_Click() Dim BMM As String Dim myReportName As String BMM = Me.BMText.Value myReportName = "BioMedRoundingReport" DoCmd.OpenReport myReportName, acViewDesign DoCmd.OpenReport myReportName, acViewDesign With Reports(myReportName)...

This is what I have tried so far... Private Sub Command22_Click() Dim BMM As String BMM = Me.BMText.Value DoCmd.OpenReport "BioMedRoundingReport" Reports("BioMedRoundingReport")("BMLbl").Caption = BMM DoCmd.Close "BioMedRoundingReport" End Sub

Good evening all, I have a text box in a form, in which users enter updates. I would like that text to become the caption on a label in a printable report. How would I write the VBA to do this? Thanks in advance for your help. B

Good Morning all, I have a combo box which populates data in a form which in turn populates fields in an excel sheet via excel automation. After I finish populating the first round of data in Excel from the form, I would like the VBA to pause or stop while I change the combo box so...

No love for me today. Thank you both for our recommendations. I tried the new DB suggestion and checking the font. Both result in the same error. I'll continue to play with it. Thanks! B

Currently the font reads as Tahoma. I use a DSUM function to populate the textbox. Thanks

I have a query and one of the fields pulls the value from a text box in a form. I think do calculations in the query based on that value. The Calculations work correctly, but the value in the query field (pulled from the text box) is displayed this way: ㌲냞䅑 Another with the same is...

Hello all, I am fairly familiar with using SQL to pull information and dropping that in a form with a list box. I haven't used reports that much and I am curious if I can do the same thing. IE use SQL to create a query and then drop those results into a report. Ideally, I have about 4 or...

I have a listbox displays information on orders and how much left there is to bill on a given order number. Sometimes the orders have several lines because there is value open on individual product ids that roll up into the order. Is there a way using VBA or some other function to check the...

Thanks Bob - works great!

Hello all, I use SQL to populate several listboxes on a form and the number format for one of the columns isn't passing from the table to the listbox correctly. Is there was way in SQL to define the format for that field? Here is an example of the statement that I have right now: str =...

Is there a way to subtract each line for the preceding line in a query. I see that people have figured out how to do a running total, but I just interested in the difference between a line and its preceding line. Any help is appreciated and I always award reputation points. THanks Brennan

I have a cross tab query that shows activity on a order over a period of time. Right now I have to export this to excel and add a column on the end with the countif function to see if there was any change in value vs the lastest value. For example, I use the countif function to check the...

Hello all, I am writing some code to clean up a string of DBs that I manage. I am curious, is there a way with VBA to check the database to see if a table, form or report exists in that db? I would construct an if statement like below. if tableA exists(need the code here) then delete...

I still get the error that I listed above. Any reason why a form would stay open why code is being run? Thanks Brennan