Search:

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

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. Print and close code runs too fast and then won't run again

    I have made a word template that I update using field codes in order to create a label.

    I have cobbled together the following code to call the template, shove values in it, set the printer to a...
  2. Replies
    19
    Views
    991

    Thankyou Bob so much, most...

    Thankyou Bob so much, most appreciated!!!!:clapping: I will study your code to try and understand where I was going wrong, I won't just copy /paste, promise! :D



    You are right, I do. I just...
  3. Replies
    19
    Views
    991

    I looked at the link and understand the examples...

    I looked at the link and understand the examples given but I don't seem to be able to translate that principle into getting what I had. --I am SOOOOO annoyed at myself --

    I normally build the sql...
  4. Replies
    19
    Views
    991

    Sadly I fluked this but then went on to another...

    Sadly I fluked this but then went on to another event before saving it, closed everything in a hurry and so lost it and now can't remember what I did. I know its in the strSQL expression.


    I have...
  5. Replies
    19
    Views
    991

    Access won't let me do it. It keeps putting...

    Access won't let me do it. It keeps putting quotes after the first line

    strSQL = "SELECT tblAllocate.ID,"




    Thanks RG, that is a better way!
  6. Replies
    19
    Views
    991

    strSQL statement being truncated

    I have the following statement

    Dim strSQL As String

    strSQL = "SELECT tblAllocate.ID, tblAllocate.JobID, tblAllocate.Dept, tblAllocate.Hours, tblAllocate.Location, tblAllocate.Comments FROM...
  7. Replies
    2
    Views
    233

    How to filter folders by part name

    We have an existing folder structure as follows for documents and pictures related to a job.

    P:\F\FRED ENG\58412

    I am attempting to write code to find a folder based on its name.

    eg
    ...
  8. Replies
    2
    Views
    256

    Possible Newbie type question but.....

    If I have the Job Number linking various tables, can I call the field JobNum in each table

    tblOriginal.JobNum
    tblDelDockets.JobNum
    tblInvoices.JobNum
    tblItems.JobNum

    or should I have
    ...
  9. Replies
    16
    Views
    2,055

    Thanks for your continued input. I have been a...

    Thanks for your continued input. I have been a reader of this forum for almost as long as I have been building/maintaining this database and came across the frontend/backend concept early and have...
  10. Replies
    16
    Views
    2,055

    Thanks for your reply. After a thorough readthru...

    Thanks for your reply. After a thorough readthru of your post I agree that option 1 is the best way to go and what I had in mind.

    Considering the info given, would SQL Server Express be enough...
  11. Replies
    16
    Views
    2,055

    Is it time to think about SQL Server?

    I constructed a database (with a LOT of help and hints from here - Big thanks to all) for work back in 2006 that has become an integral part of our day to day running. We are currently running Access...
  12. Thanks Wendel for your insight. My situation...

    Thanks Wendel for your insight.

    My situation is: This is part of my Job card procedure.
    A card is raised and items are added to the job using a subform and items table. In a perfect world the...
  13. How to add a record to a subform recordset?

    Hi All,

    I have a command that uses the following:

    If sbfItems.Form.Recordset.RecordCount > 0 Then

    to check for existing records in a subform. I have code to go on and add a record to the...
  14. I discussed this with my ISP and they are...

    I discussed this with my ISP and they are providing a replacement wifi-modem-router, hopefully this solves the problem.
  15. OK, the wired network connects 3 computers, nas...

    OK, the wired network connects 3 computers, nas box, ethernet printer, tv, 2 game consoles and the extender box to the modem/router via a 16 port smart switch. The wireless router/modem and the...
  16. devices connected to home network wifi cannot see network assets

    I have a home wireless network with a network printer and a wireless extender connected.

    All devices connected by wifi have internet access using either the wireless modem/router or the wireless...
  17. 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...
  18. Replies
    4
    Views
    558

    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....
  19. Replies
    4
    Views
    558

    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...
  20. Replies
    4
    Views
    558

    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...
  21. Replies
    1
    Views
    384

    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...
  22. Replies
    6
    Views
    1,207

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

    Thanks Pat,

    As you know that did it :clapping:
  23. Replies
    6
    Views
    1,207

    Where about did you put it?

    Where about did you put it?
  24. Replies
    6
    Views
    1,207

    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.
  25. Replies
    6
    Views
    1,207

    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...
Results 1 to 25 of 325
Page 1 of 13 1 2 3 4