Search results

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...

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...

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...

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...

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.

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.

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

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...

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...

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...

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...

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...