Search results

Hi all, I have a VB form that I would like to reference inside Access. Can someone tell me how to do this? Thanks.

Thanks Thanks for the filecopy command. That helped!

Hi all, I would like to be able to make a copy of the original file and rename it. For instance, The filename is Ph050102. If it's copy resides in the same spot then that may cause confusion. I would like for it to be copied and renamed to ph0105. The naming method I understand and that works...

Problem fixed. Problem fixed. Output stmt worked..

I would like to be able to automate exporting a table into a text file. Does anyone know the VB code for doing this process? I know I could do a "File" ,"Export" but I don't want to do that everytime. I have also tried the "output to" command and no luck.

Problem fixed. Thanks

Code Below is the code. I am converting a text file into an Access table. The text file is 467 pages. However I am receiving about 1/3 of the records. It skips the first record reads the second record then it skips 3rd record onward until it gets to the next page. Only then it reads the...

Hi all! I am currently writing some code for a custom import. The problem I encounter is that it is reading the second record on each page and skipping the rest. I need all records on that page. I have tried a movefirst and movenext stmt but the same problem occurs. Any suggestions on what I...

I have seevn different IIF statements nested within a query. This is necessary to do timeframes for a pie chart as listed below. My problem is this... I am trying to create a pie chart based on these 7 statements...but only allowed one statement at a time to graph. Is it possible to chart...

I can sort numerically without a problem. I had tried the date part and it works but not the way I needed it to. The graph contains a lot of numbers already and sorting month by number would be confusing. I need the text part. Thanks for the suggestion though.

I formatted an date using the Format([event_date], "mmm").

I am working on a chart in Access to produce a product by month. I have formatted the date to read chronologically like this: Jan, Feb Mar, Apr, May...and so on. The query works fine. It is the graph that takes the data and sorts it alphabetically...for instance Apr, Aug Dec Feb Jan July...

Thanks Thank you for your response. I wish you luck as well.

Hi, I am trying to create a search page where the user can pull a name down from the combo box. My problem is that I can't get the id to match up. My combo box just sits there. I don't have a problem on a regular form...but I am having a problem on data access pages. Does anyone have...

I am looking for code to do a search on a person's name. I can do this simple task on a form but I can't get it to work on a data access page. Any suggestions? Thanks

Is there a way to print every single line of code? Also is there a way to count every line without having to count manually. Thanks

search on Data Access Pages Hi All, I am working on creating a search page for a website based on a group of names. Does anyone have suggestions on how to do this? Any suggestions would be great! Thanks.

search on Data Access Pages Hi All, I am working on creating a search page for a website based on a group of names. Does anyone have suggestions on how to do this? Any suggestions would be great! Thanks.

Is there a way to program Visual Basic code to access the "File, Get External data, Import" Commands? Thanks

Hey There, I have the following information in a subform. The adjustment_time is a calculated fied from the previous times also mentioned. The other items listed are from a combo box. What I am trying to accomplish is putting the time and letter in the same field. For Example: Fields...