Search results

Hello Bob, Were you able to open the DB?

Thanks Doc Man for your comments. The thing I dont understand is not matter how much I requery, recalc, refresh etc. The calculated value will never equal the stored value? I cant seem to get the calculation updated and then set it to be stored.

Hello Bob, Here is a sample copy of the database. If you change the [Inventory] filed in the subform, you will see what I mean.

Thanks. I tired this and it does not work. The stored value INVNEW still lags behind the calculated value Yes.....The afterupdate is in the Subform not the individual control.

Hello, I need help figuring out this issue. Any assistance will be greatly appreciated. I have a main form and a subform. I am doing a simple sum of a field in the subform and do that with a unbound field in the footer called [INVSUM]. All works well with this and I could show this value in...

Hello, I have form that uses the datasheet view as the default view. I have a subform within the datasheet where I am summing up a field call Quantity by putting an unbound field in the footer of the subform and referring to it in the main datasheet view. The calculations seem to work but in...

Hello, I have what I thought was a simple problem but seem to be stuck and could really use some help. I have simple form, looking at inventory that I am trying to calculate the sum of the quantity of a particular part that has been purchased over time. This seems to work OK. I have a...

To boil it down to the simplest thing. I want the IIF statement to return a search criteria equal to the "CA or PA" for example. Taking out the hash tags, I cant get a simple "OR" statement to work in the IFF function. Any ideas?

Hello, Im trying to develop certain criteria in a query and having some issue adding operators to the IFF statement. In the criteria section of the query builder I have the following: IIf([Forms]![Vendor Query]![cmbMinSize]="#2", "#2 Or #0","*") I have also tried less complex as I thought...

JHB, I have tried the solution over the past few days of setting the report to open as a dialog box and it seems to work. Its does indeed for the focus to the report as I must right-click on the report to print. Have not seen the seemingly random error of print the form since. Thank you for...

So when the report is shown and the button is click on the ribbon, the report should print 1 record in a formatted way. A clue to this mystery is that to get to the report, a button on the form must be clicked that then opens up the REPORT to that one record. When the printing error occurs...

Yes....Pbaldy you are correct. The code works as it should from the point of view that the report shows the correct records in the preview mode. The problem is that when the print button form the default command ribbon is clicked, occasionally the underlying form is printed instead of the...

Thanks for the reply, I will give it a try and let you know how it works....But why acdialog? What are you thinking? Why would that help? Im not familiar with the details of the command. Thanks again Dean

Hello, I have an Access 2013 database with linked tables to Sharepoint. On several forms I have a button that when clicked, it shows the record in the report as preview. The code I use is as follows for the button on the form. Me.Refresh DoCmd.OpenReport "rptquoteExtreme", acViewPreview, ...

Thanks....Dont know how I missed that...Guess I have been looking at it too long. Your overall solution was PERFECT!!! Thanks for the help. Dean

Thanks Jon, That information you sent seemed really good. I think I am really close to getting it to work but still getting an error? "Number of query values and destination filed are not same" Any Thoughts? Private Sub cmdOrder_Click() Dim strSQL As String Dim strSQL2 As String Dim...

Thanks for the reply....Im not sure if I am following you completely but let me show you what I am doing with my code... Dim strSQL As String Dim strSQL2 As String Dim strMAX As Integer ' Sets a Variable to be New Foreign Key Value for SubForm to the Latest Value strMAX = DMax("Order_ID"...

Hello, I have button the when pressed will insert a record (via an insert into query) to the frmMain and several records to the frmSub. The problem is when a new record is created in the main form the auto number primary key advances. This is fine however the linked Child field which is a...

Hello, For the life of me I cant seem to figure out the correct syntax and was hoping someone could provide some help and the specific syntax needed. I had a form "Quotes" that worked perfectly and upon clicking a button opens a report using the following code and set the Quote_ID to the...