Search:

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

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    2
    Views
    121

    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
    ...
  2. Replies
    13
    Views
    1,036

    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...
  3. Replies
    13
    Views
    1,036

    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...
  4. Replies
    13
    Views
    1,036

    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...
  5. 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...
  6. 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...
  7. 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.
  8. 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...
  9. 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...
  10. 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...
  11. Replies
    4
    Views
    464

    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....
  12. Replies
    4
    Views
    464

    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...
  13. Replies
    4
    Views
    464

    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...
  14. Replies
    1
    Views
    324

    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...
  15. Replies
    6
    Views
    1,029

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

    Thanks Pat,

    As you know that did it :clapping:
  16. Replies
    6
    Views
    1,029

    Where about did you put it?

    Where about did you put it?
  17. Replies
    6
    Views
    1,029

    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.
  18. Replies
    6
    Views
    1,029

    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...
  19. Replies
    5
    Views
    1,398

    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...
  20. Replies
    5
    Views
    1,398

    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. :)
  21. Replies
    5
    Views
    1,398

    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...
  22. Replies
    1
    Views
    316

    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,...
  23. Installed the latest version of Virtualbox 4.3.10...

    Installed the latest version of Virtualbox 4.3.10 and Android 4.4 loaded fine!
  24. 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...
  25. 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...
Results 1 to 25 of 318
Page 1 of 13 1 2 3 4