Search results

  1. L

    Incorporating VB form inside an Access db

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

    Copying/date questions

    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...
  3. L

    Exporting an access table to a txt file

    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.
  4. L

    Skipping a few records

    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...
  5. L

    Trying to create Pie Chart based on iif stmts

    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...
  6. L

    Sorting dates

    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...
  7. L

    Data Access Pages--combo box

    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...
  8. L

    Data Access Pages

    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
  9. L

    Printing source Code

    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
  10. L

    search on Data Access Pages

    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.
  11. L

    search on Data Access Pages

    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.
  12. L

    Import Data

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

    Calculating and inserting a text item in the same space.

    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...
  14. L

    Dlookup and Combo boxes

    hi.. I have created a subform that looks like the following: Text Boxes Combo Boxes Btime Etime Item1 Item2 Etc. 1200 1250 50 A I am trying to achieve the 50 A part. I was going under the assumption that the 50 is a calcuated dlookup function from btime and...
  15. L

    Making label visible...

    Is it possible to bring a label to the front when the button is clicked? I have an image for the button....that is why I am asking.... Thanks....
  16. L

    changing name format

    Does anybody know how to change the following text using code.... John Doe to Doe,John
Top Bottom