Search:

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

Page 1 of 14 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    2
    Views
    172

    Thanks for the input Wendell, I like the idea of...

    Thanks for the input Wendell, I like the idea of tracking the version of components. It would be only for us 2 developers when we "commit" a new version (whole frontend db) to the server so that he...
  2. Replies
    2
    Views
    172

    How to Merge Database objects (Not Data)

    I run a frontend/backend database setup here at work. When I alter the frontend and commit it to the server my process updates a version table in both the front and back end db's. When a user opens...
  3. [SOLVED] Lettered Networked drive doesn't show in "save to" folder lists

    I have come across several examples of this since upgrading to window 10, both on my home and work machines.

    I have drives W: X: Y: & Z: which are networked folders on my NAS box.

    With win7...
  4. Thread: Printing Issue

    by weyrman
    Replies
    3
    Views
    281

    It has an ethernet connection. Will get new...

    It has an ethernet connection.

    Will get new drivers
  5. Thread: Printing Issue

    by weyrman
    Replies
    3
    Views
    281

    Printing Issue

    My wife and I are running win 10 and share a networked printer but the standard print function on the share tab will not work for her.
    She selects a file and clicks print. The print pictures box...
  6. 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...
  7. Replies
    19
    Views
    2,384

    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...
  8. Replies
    19
    Views
    2,384

    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...
  9. Replies
    19
    Views
    2,384

    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...
  10. Replies
    19
    Views
    2,384

    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!
  11. Replies
    19
    Views
    2,384

    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...
  12. Replies
    2
    Views
    474

    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
    ...
  13. Replies
    2
    Views
    427

    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
    ...
  14. Replies
    16
    Views
    3,813

    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...
  15. Replies
    16
    Views
    3,813

    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...
  16. Replies
    16
    Views
    3,813

    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...
  17. 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...
  18. 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...
  19. 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.
  20. 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...
  21. 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...
  22. 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...
  23. Replies
    4
    Views
    767

    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....
  24. Replies
    4
    Views
    767

    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...
  25. Replies
    4
    Views
    767

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