Search results

  1. S

    Trouble with default value

    Is this what you are trying to do? check out my little attachement.
  2. S

    Customised message on each report..

    Make sure you dont close your form first before you print your report or you will not be able to resolve the txtfield on your form.
  3. S

    Help with TransferText importspec

    I am attaching a simple mdb I am creating to read in a bunch of txt files with no delimeters. 1) I created an import spec called "VartecImportSpec" 2) I can manually file/import my text file go to advanced and select my import specification & save the data to my tblVartecImport with no...
  4. S

    Sendobject

    Here is my send object line... DoCmd.SendObject acSendQuery, "FormatClub", acFormatXLS, "<greyhound48@comcast.net>", "<sharlan@allamericaninsurance.net>", , "ACTIVE CONTRACTS", "Please let me know if you see any problems with the attachment.", False I have this working, but there is a funky...
  5. S

    Printing an external report

    Printing an external pdf document Hi Everyone... I dont want to print a access report to a pdf from access, I want to print a static external pdf help document from access after my true access reports have printed. Help!! Cant figure this out.
  6. S

    Terminal server and networked printer in access

    We currently use Terminal Server to run an Access 2002 mde which I wrote. I have designed a front end which is pushed out to each users desktop and a shared backed on the server. Users run the application through the Access2002 runtime. I have implimented Microsofts Application.Printer Code...
  7. S

    Lookup combo box

    Suggestion Off the top of my head...... try something like this... 1) In the properties of you combo box, go to the data tab and check limit to list. 2) On your event tab select "on got focus" and create an event procedure and paste something like this in it. yourcomboboxname.requery this...
  8. S

    Pre-printed membership card forms

    Possible Solution When Creating your report have you tried using the label wizard? Under Reports, Select New, Label Wizard, Customize, In the new label size menu select NEW, then you can control how many across and margins and height. Hope this helps.... :)
  9. S

    VBA problem driving me nuts!!!

    timer event Is there a way to turn off the timer event when editing another form without putting my logon screen in design mode?? My timer event is on the login screen and I make it invisible after login so I can grab custom security info from it for other forms and reports... I really dont...
  10. S

    VBA problem driving me nuts!!!

    HELP!!! All of a sudden when I type in the VB editor of a form each character typed turns red and it automatically erases spaces that I type. I used to be able to type a whole line before the editor would evaluate my typing. Does anyone have an idea of whats going on????
  11. S

    Combo, List, and Subform Problem

    solution Hi Rich, Your problem is in list4 you need to change your bound column from 1 to 2. This is because your subform is looking for acft;edate from combo2;list4 and your query is returning 3 variables acft, edate, and ttrans but you have set your list to 0";0.7";0.4" so acft doesnt...
  12. S

    hide the close "X" and "max." of Acces

    disable main titlebar X Check out this link.... http://members.cox.net/larrytuaz/access_help_pages/disable_form_database_closing.html
  13. S

    Changing fields based on selection

    Hope this helps In the "on open" event of your form set up an event procedure which sets all the fields you want to turn off and on by using the .visible method. example... yourfieldsname.visible = true or false then in the update event of your listbox set up an event procedure which...
Back
Top Bottom