Search:

Type: Posts; User: weyrman; Keyword(s):

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. VSE2012 VB: Causing a new page when printing

    I have written a small program to calculate XZ positions on a manual lathe to create a large radius and I use a do loop to print the positions. I use a large font for easy reading by the turners and...
  2. Replies
    4
    Views
    252

    Do you mean that you are going into design mode...

    Do you mean that you are going into design mode of the form and then clicking on the subform that is embedded in the main form? If so that is a real puzzle....

    Yes, this is exactly what I mean....
  3. Replies
    4
    Views
    252

    Wendell, Each user has their own copy of the...

    Wendell,

    Each user has their own copy of the FE. The form shows only 1 record at a time and only a max of 10 records in the subform. Only 13000 records in main table.

    Tell me more about...
  4. Replies
    4
    Views
    252

    Excessive time when editing forms

    I run an Access 2007 FE/BE system with name autocorrect turned off.

    When editing a form and clicking into a subform, I get the busy circle for close to 2 minutes before I can do anything and the...
  5. Replies
    1
    Views
    198

    Syntax help please with str SQL statement

    A button on my Quote form (frmQuotes) causes a maketable query to run. The created table is then read to provide data for creating a word document. This all currently works fine.

    I am out to...
  6. Replies
    6
    Views
    636

    Thanks Pat, As you know that did it :clapping:

    Thanks Pat,

    As you know that did it :clapping:
  7. Replies
    6
    Views
    636

    Where about did you put it?

    Where about did you put it?
  8. Replies
    6
    Views
    636

    here is a trimmed down copy of the front and back...

    here is a trimmed down copy of the front and back end. You will have to relink the back end tables. you will see that the sub menu options don't work even though all the code is there.
  9. Replies
    6
    Views
    636

    Access 2007 switchboard issue

    I have been happily running a FE/BE system for quite a while with the FE using an .accdb and the backend being an .mdb. The switchboard was originally built in 97 and has migrated up through 2003 to...
  10. Replies
    5
    Views
    1,046

    I found an excellent code module here...

    I found an excellent code module here that creates a bat file that closes then reopens the database that ran it. By simply adding lines to it that copied the DB from the "server" where the latest...
  11. Replies
    5
    Views
    1,046

    That's actually what I have right now but I...

    That's actually what I have right now but I thought it would be nice if I could get it to be fully automated. :)
  12. Replies
    5
    Views
    1,046

    Need help with code

    I was looking on the net for ways to update the users FE and came across the following code which I have tried to adapt for my needs


    Dim WSHShell
    Dim appAccess ' Current Access...
  13. Replies
    1
    Views
    220

    Populating a listbox to sort it

    I have a listbox that is populated by the action of a combobox using the following rowsource:


    SELECT tblAllocate.ID, tblAllocate.JobID, tblAllocate.Dept, tblAllocate.Hours, tblAllocate.Location,...
  14. Installed the latest version of Virtualbox 4.3.10...

    Installed the latest version of Virtualbox 4.3.10 and Android 4.4 loaded fine!
  15. I have the same problem. I am running win7 64bit...

    I have the same problem. I am running win7 64bit with virtualbox 4.3.8 and iso 4.4-rc1. 4.3 as stated in the article I can't get to download.

    The last command on the screen is Kernal panic - not...
  16. Wendell, Yes, sorry about using the wrong...

    Wendell,

    Yes, sorry about using the wrong terminology, I have subforms shown as datasheets that only link the .sourceobject specified when the tab is selected. What I need is the best point to...
  17. How to trigger an event when next/previous record is clicked on a form

    I have 2 sub queries on a tab that have their .sourceobject = ""

    My reason is that the sub queries do a big sort for purchase orders related to the job and were going off every time the...
  18. Replies
    1
    Views
    313

    I worked it out! Set rst =...

    I worked it out!

    Set rst = sbfItems.Form.RecordsetClone needed to be Set rst = me.sbfItems.Form.RecordsetClone

    and I also needed to define my variables
  19. Replies
    1
    Views
    313

    Properly reading the recordset

    My scenario:
    1. Items for a job are kept in an items table and are shown in a subform when the job form is opened.
    2. When a delivery docket is formed rows from the the items table tblItems are...
  20. vbe2010 printing with columns and then on next page

    I will start by admitting that the print routines used were cut and pasted without really understanding what they do beyond a general haziness.
    I was able to adapt the basic structure to get what I...
  21. Replies
    4
    Views
    706

    Yes they do, but we still get occasional locks...

    Yes they do, but we still get occasional locks when people are trying to access the same record
  22. Replies
    4
    Views
    706

    Closing an unattended form

    In our shared database is a job form which causes lock issues from time to time with people leaving it open.
    I would like to put a timer on the form lostfocus event that will cause the form to close...
  23. Can I hide a network drive icon without disconnecting?

    Is there a way to hide a network drive icon in the "my computer" window? I need the drive access for backup purposes (my responsibility) but don't want the drive to be visible to anyone who accesses...
  24. Replies
    1
    Views
    586

    Help with ribbon function

    I use IDBE Ribbon Creator to build a custom ribbon for my db.

    I don't fully understand all the available functions but up to now have been able to create what I want. The program inserts a few...
  25. Formatting a calculation result in VB Express 2008

    I have a 6 to 9 decimal number as the result of a calculation and I need to reduce it to 3 decimals before I write it to a text file. Is there a quick way to do it? Or do I have to *1000 it, int it...
Results 1 to 25 of 309
Page 1 of 13 1 2 3 4