Search results for query: *

Hi I have a BE/FE on two PCs with the BE being on the first PC and both users FE have links to the BE. The database was working fine until the PC where the BE is located was replaced. The database is working fine on both PCs BUT records that are entered from the first PC are not visible by the...

Yes, each pc has its own fe and be is on a server

Hi I posted this in forms as well but I believe it should be asked here. I have an Access database (front and back end, data in access, linked)created in Access 2000 that used to be working on XP machines for years without a problem, in office 2002-2003 and 2007. Then we got some pcs with...

Hi I have an Access database (front and back end, data in access, linked)created in Access 2000 that used to be working on XP machines for years without a problem, in office 2002-2003 and 2007. Then we got some pcs with Windows 7 and the database started having problems. First it crashed...

Hi, I have a database that is on a shared server folder. Several users open the database without a problem. These users may have Access 2002, 2003 or 2007 and Windows XP installed in their PC. A few days ago a new computer with Access 2007 and Windows 7 was connected to the network. At some...

I have the following code that works fine on MS Access 2002. DoCmd.TransferText acExportDelim, , "ZSTALEO_TBL", "c:\ZSTALEO.txt", False However in Access 2003 it does not and it gives Runtime error 3441, "Text file specification field separator matches decimal separator or text delimiter" Any...

Dear All I have upsized my database and came up with a lot of questions. I have posted a question on a problem I am having, but after reading a lot from this forum I want to ask you to tell me where I can find info on starting after upsizing. For example, some of the questions that I need...

George, thank you for your answer. I am not at work at the moment but I will check it out tomorrow. Another thing is that some queries with expressions work, some do not. Could it be the joins? Should I make them simpler? I have upsized only the tables, is it relative? I am new to SQL and...

I have developed a database for a hospital in Access 2003 that I have upsized only the tables. Some portions of it run smoothly but there some parts that do not. The major problems until now are the following: 1. I am using true or false as boolean expression, but I have noticed that the SQL...

I got it to work. It seems that the fact that I had three columns in my second combo box was creating the problem. I made it simpler and it workod. Thanks for the tips.

Dear lupins I mean that I cannot see the values stored. The Bound Column is correctrly set to 1.

I have a continue form that has two combo boxes. The one is for selecting the group and the second takes in the selected group and shows the related records. This works fine. I ve been using this until Access 2000 with no problem but now that I am using Access 2003 I noticed that although the...

Dear Tony Ignore last message. I had a misspelling somewhere, your solution is excellent! Thank you very much! Rgrds Stalo

Dear Tony Your solution is exactly what I wanted. I have included them in two functions and I rotate through the available Thursdays. But unfortunately the code for the Last Thursday does not work properly because when is year 2006 it says 2005 and it does not change. The code for First...

What I am looking for is an automated way to press a button and go to the first or last Thursday of the month. In the form I press a button and I calculate the next available appointment date with code. I do some checking and if the appointment date is full I go to the next available date. The...

I am preparing an appointmemt scheduler for a hospital and there are two clinics that want to have appointments, the one every first Thursday of each month and the other every last Thursday of each month. I have checked the forum but could not find exactly what I was looking for. Any...

We are about to upsize our database to SQL Server. There are two problems we are facing that I would appreciate your comments. After we create the front end with the linked tables pointing to the SQL Server, I want to link to a table in another SQL database. This database will also be upsized...

I have the following function that gets time as a parameter in the form of 8:00:00am. I format it to "h:mm" but still continues to be 8:00:00am. The field is formatted as Short Date. I also have a Query where I group together all appointments scdheduled for the same time. I created a DLookup to...

I copied this cde: Sub listprinters() Dim devs As devices Dim dev As device Set devs = New devices For Each dev In devs Debug.Print dev.printinfo Next dev Set devs = Nothing End Sub and I get the error : User-defined type not defined. If there is no library to set, what could be wrong?

I need to know which vba references to set if I want to use PrtDevMode, PrtDevNames etc. I have my references for ADO and DAO but it does not seem to recognise it.