Search results

I was afraid that was the only answer. Thanks a lot.

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

OK, getting closer, I think. It is [txtGST] the problem.....but only on A2010 ??? I made the text box visible and it shows #Name, opened the same form in A2003 and work perfectly. The format of "txtGST" is Standard (if it means anything) Anyway this text box control is "gnGST" and this are...

I did some changes and now the errors happen on 4 lines (with --->). No idea what is wrong. The only common thing is [txtGST] but there is many instances of [txtGST] below the errors and thay don't trigger errors??? Does anybody have a clue? Please help. Thanks Dim myHST As Single Dim...

Thanks again. Working on it when I get home tonight.

Thanks a lot for your response. Like I said I am not expert and it will take me a while but I will figure it out how to simplify thing like you said. The one thing I don't get at all, where is the "1" coming from? Thanks again

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

OK, for future reference (no pun intended), the file that was missing was: MSCOMCT2.OCX I read in the net that it had to be added to System32 but for some reason every time I added it it disappeared :confused: , finally I added it to SysWOW64 (and then automatically showed in System32) and it...

Thanks for your response. What do you mean "compliance mode"? Do you mean "XP mode", that is only available on W7 Professional, I think. I hope you can remember more. Thanks again.

I just realized that W7 Home is not part of the problem, I tested on another computer by loading W7 Home/Office 2003 and everything works perfectly. And as far as testing the small sample database that gives me the "Unrecognized database format" error, is definitely not corrupt, I tested it in...

Thanks for your response. 3 times I had to reinstall office, following every time I reinstalled windows. I am searching to no end, and I am starting to wonder if the windows version I have might have something to do with it. (W7 Home Premium) In my Macbook (with Parallels) I am running W7...

Thanks for your response. I specified I was running Access 2003 (SP3), and I did say I got an error on my "mde" (it would have to be after it opened), there will be no way to open a database without Office, I think. Thanks anyway! PS: It remind it me of an old "joke?":D; yes the computer is...

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

Thanks a lot!

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.

Thank you very much to everybody that mentioned "IsNumeric" I ended up doing it as simple as possible for my purpose, making a query to add to my larger query: SELECT Orders.OrderID FROM Orders WHERE (((IsNumeric([OrderID]))=False)); Thanks again!

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

Thanks a lot. It shows how little I know!:eek: