Search results for query: *

I have a report in my database that when the user clicks on a button they are asked for the report number and then I have a macro set up to send the report and close the form. I have a minor issue when they click on the button a screen comes up and asks for a Profile. I guess this is comming...

Thanks Guys..... I really appreciate the help. efrank

I have a database that I have been working on for a couple weeks with just a few forms in it. Recently I wanted to add a button that when clicked on would open another form. This use to work.. I would just click on the add button icon on the tool bar and place the button on the form. A menu...

I have a combo box on a form that lists description of defect types. This combo box is based on a table called Defect Codes. Sometimes we need to add a defect description so I created a small form that can be opened by a button on the main form to add the defect. However the defect then doesn't...

Is there a way that you can play or "display" a very short AVI Video file on a form? I have a form that I want to illustrate an action for the user, using an AVI file. I have this file called F1.avi I've placed an unbound Object Frame and the AVI on my form. But the AVI doesn't play. It just...

CosmoKramer..... You weren't missing anything. I tried that and it works great! I thought I had tried that before. Thanks a bunch. efrank

O.K. Melagan.... That works. But I don't want to have to keep changing the date in the query. I want this to be dynamic so that whenever the user opens the form it displays the data or records for whatever date it currently is. Does that make sense? efrank

Is your data entry field set to yes on the form? efrank

Melagan, Yes like a dummy I named the field Date. I know better than to do this but just wasn't thinking at the time. I have now renamed the field InspDate. I retried the query with this Where Int([Inspection Log].[InspDate])=Int(Date()) and got back the same error. I'm not sure where to put...

My table name is Inspection Log and the field name in the table is Date. So in the query criteria for the date field I wrote WHERE Int([Inspection Log].[Date])=Int(Date()) and got an error message: The expression you entered contains invalid syntax. You may have entered an operand without an...

Can anyone help me figure out how to show only the records from a table in a query for the current date. For example I have a table that has many records for each day since last year. I want to show on a subform only the records that were entered today. (within the last 24 hours) or today's...

Is it possible to show the running results of a calculation on a form? I have a form based on a table for data input. There are 6 fields called CTF1 thru CTF6 for each record. On the form I need to show, as the user is entering the data into each field, the Total, the Average, The High and the...