Search results

Hi jkl0: Thanks for the link. It was not so much to keep it all within vba as opposed to just having one location to maintain. So the import problem was taken care of and now the export problem has two easy fixes. Save the file with .txt extension and then rename the file to .csv if I really...

Hi: Ok, that sound promising. I have designed the form so that all the controls are the same size except for the first two controls. The first two are for date and sales area and will never change. So for now I have bound the controls to match the query and the form is saved and the form view...

Hi: I have no problems creating forms (my knowledge is rusty so I do not remember all the tricks I used to use) and binding a table or query to the form and I have no problem binding a field to a control. I just need to make sure that the terms you are using fit with my understanding of how...

Hi Pat: That would have saved me a lot of time searching for solution, but then, I found a lot of other stuff I had forgotten. Of course that is the way to learn. Hi Jklo: Yes that was another option I had considered but eventually rejected for an option just within vba to keep it simple Thanks

Hi: I do not see how that would automate the process. If I understand you correctly I or the user would have to change the form each time the recordset changes. Thanks

Hi: So my vba code would open the recordset and create/modify the form to match the fields in the query recordset and then then data would display properly? Ok, I do believe I have read other help topics on creating a form from within vba. So then, back to the drawing board. Thanks

Sorry: Old habits are hard to remove sometimes. The Crosstab is summary of sales by day for each sales area. The Crosstab query field defined as column headings will become the field names the form or report will see. This means that the field names produced by the Crosstab could be...

Hi: The X-Tab produces a varying number of fields and the first record from the X-Tab will be a label to identify what the values of each field represent. So I would like to display on screen for the user see the results from the X-Tab query. The form allows the user to select a date range...

Hi: I recently ran into another problem with the text import/export feature of access 2003. After some heavy thinking, head scratching (creating more thin spots), searching the net, etc I believe I found the answer to my new question and this question. So for anyone else who find this...

Hi: I have created a continuous form bound to a query (X-Tab) where the detail row is a series of unbound text boxes. I then wrote some vba to populate the detail row from the query recordset. (The vba code also populates the heading row which are also unbound text boxes.) Everything works...

Hi: Thanks for the clarification.

Thanks. That works great. One of my original ideas was to create/copy the sql statement into vba code and then run the code with the DoCmd.RunSQL from within vba code. But, then I was also wondering which use less resources and is easier to maintain. So, it really does not affect your...

Hi: Thanks for the link and the aircode. I had read earlier about change the sql for the query but have not had a chance to test it. Is the change to the query permanent (not a problem, just curious), and it this better than doing a DoCmd.RunSQL statement? Thanks

Hi: Back on the net to do more searching. I found http://social.msdn.microsoft.com/Forums/lv/accessdev/thread/589cff8b-8536-4794-a9b5-5a106ef74c8d that describes my problem with Date Picker with the exception that they are using Access 2007. They were, however, using the same version of Date...

Hi: Had to check on that and sorry the answer was no. However if it helps, the Date Picker if from the toolbox and is MS Date Picker 6.0 SP4 which is standard with Access 2003. Also I note in the Others property tab there is a Value property which allows me to set a default date. I just need to...

Hi: Access 2003 with windows XP. Thanks

Hi: Thanks for the reply. I have two Date Picker controls: one called FromDate and one called ToDate. I have tried various ways to change the date. For test purposed the code is Me.FromDate = DateValue(Now()-1) to set the FromDate to yesterday produces the run time error DatePicker is read...

Hi: For the application I am developing I have created a X Tab Query to produce a listing in a form (use is unlikely to print this) showing the results of the X Tab Query. Now I need to find some way to automate the query to limit the information based on date. So I am looking for suggestions...

Hi Michael: Thanks for the links and the suggestion. For now I am handling the problem by canceling the update on a new record. I do not allow the user to access the dept field so if the dept field is zero then cancel update and move the user back one record. Thanks

Hi Michael: Thanks for sticking with me.