Search results

SJ McAbney, Sorry another dumb question. Where do I put: Me.Status.Requery I tried it here and it didn't work: Private Sub status_AfterUpdate() If Not IsNull(Me![status]) Then Call CalcTotal Else Me![Total] = 0 End If Me.status.Requery...

Sounds good! I give it a shot. Thanks for the help. Don't want to ruffle any feathers, but wouldn't it make sense to put the answer in the thread so that future idiots can find relief? Anyway, don't want to be considered as a "non-searcher". I appreciate taking your time. I have found this...

SJ McAbney, I don't know how to do this. If you feel that DCount will work better, can you please walk me through what to enter? Adam

Anyone? I would really appreciate the help. Adam

I have a database that has records at different statuses along the process, like "created", "submitted to finance", etc. I have a form where I can choose the status from a dropdown and it will total the number of records at that status and display in an unbound field "Total". My only problem...

I have search the forum and cannot find an answer, can anyone please help. I have a few field in my table that have number and I would like to be able to enter decimal place numbers like 8.25. I have set: Field Size = 'Long Integer' Format = 'General Number' Decimal Places = '2' When I go to...

Thank you! I should have just thought about it that! Adam

I have a button on a form where the user can simply click and the date will be entered into a field. I would like to make it so the date and time can be entered, but I am stuck. Under the event procedure of the button I have check_req_date = Date The field is set to General Date so the time...

Is it possible to have a make table query inside a split database? Thanks for the help! Adam

Anyone? Thanks, Adam

maxmangion, Thanks for the suggestion. Actually the tbl_contract_export is based on a make table query that pulls data from all tables and sends it out to excel. tbl_contract_export isn't a permanent table and only contains data based on a certain status that we export. The Doctor...

Is it possible to have a make table query inside a split database? Thanks for the help! Adam

frm_contract_qry Is it possible to change the relationship type and that would solve the problem altogether? Adam

maxmangion, Thanks for your willingness to help. Here is a copy of the database where I use the Query for the form, but I cannot add any records. Thanks again! Adam

So if I switch back to a table driven form and have the form do the calculating will that work, right? And then when I need to work with the data I can use the query that includes the calculations, correct? Thanks, Adam

Anyboby! I would really appreciate a quick response. Adam

How I currently have it setup is that I have about 4 fields that have formulas that calculate based on data input from the user. It is not reccommended or easy to do calculations in a table so I created a query based off of the table and added the calculations. My only problem is now I cannot...

Hello All, I am new to this wonderful forum and I am amazed at the group of Access Professionals that is assembled! I have a hopefully a short quick question. I have setup a database that uses a form based on a query (because I need to calculate fields). I would like to be able to add...