Search results

  1. W

    How to connect to the tables

    Hi all, I just changed the linked tables from "C:/Access/my_be.mdb" to" //Server/Access/my_be.mdb" I did it in the office while connected to the "Server" Now away from the office I need to make some changes to the "front end" but can't access the linked tables and "my_fe.mdb" won't start. Is...
  2. W

    There is an invalid use of the . (dot) or ! operator or invalid parentheses

    Hi everyone, I am a newbie of sorts and in need of help. When I open a form in A2010 I get the error, but it works flawless in A2003 (is an mdb). In debug I found the problem in 2 lines (--->) I can't figure out what is wrong, I searched the net to no avail, nothing similar to my problem...
  3. W

    Using replicated mdb on Access 2010

    Hi all, I am an amateur programmer and made an .mde and .mdb (replicated) to run my small business, and 10 days ago lost my building/business, including computers and software (luckily I had my laptop off site). google: olympia house collapsed I am pretty much forced to upgrade to A2010. I...
  4. W

    Unrecognized database format problem

    Hi all, Happy New Year! A very strange problem is driving me insane. I am not a novice not an expert but I have been working with Access for many years. I use many computers with my own replicated database to run my business. I am trying to update 1 computer (have 5 running same database 2...
  5. W

    No custom Icon on Windows 7 taskbar

    Hi all, I just noticed that my custom database icon does not show on the taskbar on Windows 7 like it does on Win 200, XP and Vista. Instead the Access icon shows. Anyone knows how to fix it? Any help greatly appreciated.
  6. W

    How to do this?

    Hi all, I am trying to show records that have more than just numbers. If I have: 4536 3452C 7642-B 2314 Thomas 5432 I need to show only: 3452C 7642-B Thomas Don't know where to start. Any help really appreciated.
  7. W

    Autopilot and Vista

    Hi all, Does anybody know it Autopilot works with Vista. Thanks for your help, Emilio
  8. W

    Any other way other than copy and paste?

    Hi all, I am a newbie and need to copy a calculated result from a textbox ("txtAmountEnter") to another ("InvAmount") whose control source is a field in a table (therefore not able to hold a calculation). I have been using: ======================================== DoCmd.GoToControl...
  9. W

    Refer to parent form in standard module

    Hi all, I have a Form with a combo box that I access by pressing F6 with the following function (converted from a Autokey macro): Function AutoKeysF6() On Error GoTo AutoKeysF6_Err ' Find PO# DoCmd.GoToControl "FindPO" AutoKeysF6_Exit: Exit Function AutoKeysF6_Err: MsgBox Error$ Resume...
  10. W

    How to avoid duplicates in append query

    Hi all, I have an append query that I run daily and want to append only records with different OrderID. ------------------------------------------------------------------------ INSERT INTO tblConfirmSchedule ( OrderID, JobCode, JobDate, Status, [Home#], [Work #], Ext, [Other#], Ext2 ) SELECT...
  11. W

    Tables for Price List?

    Hi all, I started a new thread, because it is a new subject even though is related to my Price List thread, I hope is OK. If someone can please take a look at my attached Excel Price List (particulary the factors sheet) and give me an opinion of how my tables should be created. I cleaned the...
  12. W

    How to create a Price List

    Hi all, Before I start, please know that I am what you call a newbie to a certain extent even though I created in the last 3 years a very complex and efficient database for my business. This is going to be hard to explain, but I'll try. The time came to stop creating the Price List in Excel...
Back
Top Bottom