Search results

try my suggestion first. Also you down load winzip for free.

Try creating a group query for each table using the sum. Create a forth qery having a three in it and do the math using expressions

yes. How big is it.

Can you post it?

Attach it.

What kind of text file? Access supports importing of text files already

For the Code of your button Forms!YourForm!yourfield=Me!yourfield

There are other ways but I would just make the forms pop up. They will still see all the items but won't be able to use them including the close on the main window.

Thanks Rich, I found something else @ peters Software

Ok selecting the db at start up doesn't help because its not that window. Tried creating a splash screen but I need to find some code to size the Access window cover it with it.

Compiled and compressed already still the same.

I'm using the hide access code, when access itialy opens I still see the access window for a few seconds what can I do to speed the code up

Got It need the = for the criteria. Pbaldy helped me.

I have no idea what the "Where 1=1" does. I have barrowed the code from an example. I'm trying to requry a sub form based either or both text boxes. here is the original Private Sub cmdSearch_Click() On Error Resume Next Dim sSql As String Dim sCriteria As String sCriteria =...

Ok I get a syntax error Missing operator in qury expresion 1=1 And medicalrecordsupdating.serial "30000" And medicalrecordsupdating.event "Acceptance Testing" whats the problem besides the fact I don't know VB Private Sub Command14_Click() Dim sCriteria As String Dim sSql As...

I'm trying to requry a sub form based either or both text boxes. I need help with the code. I'm trying to rewrite something from a sample but can't seem to get it to use the criteria. It does requery though. Private Sub cmdSearch_Click() Dim sCriteria As String sCriteria = "WHERE...

I'm using the hide access window calls. So When I preview a report it has to go through the snapshot but I want to supres the print output message that appears and use a progress bar instead. Any way to supress the message box and call aprogress bar.

I was trying to get away from doing it manualy

Thats already been done but because the isle doesn't have any records it will show but the next row comes behind it I want it to show each row in a new column.

I'm trying to do do a floor layout on our warehouse. We have rows where we park pallets. Every two rows there is an isle I want to create a report to show the layout but to aacount for the blank isles. Is there a way to do this.