Recent content by gw73

I am doing this now on a pocket pc. I am a beginner so I hope someone else with more experience posts a reply. First there is no Access program for the pocket pc. You will need ActiveSync and Embedded visual tools which is free from Microsoft. Autonumber is not supported and you will have to...

Thanks for taking the time to answer. I am still very new at access and VB in general. I have done similar things with a single form, select a value in the combo box and then place a button on the form to preview a report based on a query with the value in the combo box. This time I need two...

I have two parameter set in the criterion box and it works just find. The criterion is Like "CP-" & [Select the Cup Repitition:] & "*" And Like "CP-????.???." & [Enter the Cup Sample Depth:] When I changed it so I could use combo boxes instead of paramater boxes to...

Thanks to both of you for sending me in the right direction I'm sure to visit this forum more often. GW73

I am still new at access and need some ideas. I have created a database that I would like to send the results of a query to an excel spredsheet, once there I need to do some statistics that are not available, at least not affordiably available in access, I would like this automated so the user...

Thanks for the idea, I didn't use your idea exactly, but it gave me an idea that solved my problem. These forums are the greatest thing around. GW

Hi I am still new to access and have some basic questions. I have a table that I can set up two or three ways and I don't know which is proper. The first field is plot number which is a simple 4 diget text string that identifies a plot, the second is project number which identifies the project...

Thanks for taking time to answer. Money is an object, but I think I'll go with a pocket PC because of the Access connection. Does anyone have any thoughts on the Jornada 547 or 548? GW73

I've never owned a PDA and I need to buy one for a final project in my CIS class. I've built a database in Access and I would like to load the forms in the PDA so the user can go out in the field and load information bring it back and download it into the desktop. I'm open to any ideas and any...

I finally figured it out, I have a funny name for the form and it had a typo. Thanks for the help. That solved my problem. GW73

Thanks for replying, but I can't get to work, all I get is a Requires an object name argument message box, I'm still pretty new at this and I assumed this would be the name of the form, if you have an ideas I'm open for suggestions. Thanks GW73

Hi I've created a form with an unbound combo box to select a criterion for a query that is used in a report. I also put a command button on the form to open the report in the click event. Everything works fine except I want to unload the form after clicking on the run report button so the user...

Thanks for the information you've been a great help. Gary

Hi I would like a combo box to come up so the user can pick a search criterion. I've searched the threads and this is what I have done so far. I created a form with the combo box and put a run query command button on it. It works fine if I run the query from the form. I have two questions, first...

Thanks for the information I wont worry about it