i have data base in ms access. when i want to open that database than it open in ms access.now i want make its application so that it open without ms...
Thanks John, Yes, a Green arrow is appearing on server icon. So it means it installed succesfully. I created ADP and connected with the server. I created...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Mar 1, 2005 12:42 pm
23708
Adam, Out of 2080 records in table named Production, 14 are found to be bad. On removal of these defective records, your report is working fine. Your file,...
Ahmad- You must own a copy of the Developer Tools to be able to create a Runtime install package that you can give to a user who does not have Access. Also, ...
A.D.- As I noted earlier, I had started to look at Adam's file and was making an attempt to simplify his query. It hadn't occurred to me to look at the ...
Ashfaque- You should have a command button wizard available also in an ADP - just make sure the Wizards button is clicked in the Toolbox. I'm not sure I ...
John, I only have ArriveOnTime and LeaveOnTime as yes/no data types. I didn't want to have yes/no for Homework and RaiseHand as there could be partial points....
Here's A.D.'s December 6th posting regarding this subject. Beth M If you are keen for an SQL based solution for direct deletion of duplicate records (beyond...
I am trying to make my first attempt to work with unbound forms. In my close button for the form I have the following code. But If I open the form with data...
Hi John, Thx for your reply! Using your suggestions: a) I changed the bound disease history fields to unbound fields b) Have not changed report's underlying...
Ok this is my query its just pulling information from other queries to make a report query. For statistic for our members. The problem is that it list a few...
John- So, Homework and RaiseHand contain a numeric value? Then the query needs to look like: SELECT tblStudents.StudentLastName, tblStudents.StudentFirstName,...
Todd- Are any of the values floating point (Double or Single) numbers? Because these are imprecise values, your test for equality might be yielding a false ...
Sandra- Try this: Public Sub PopulateHxTextBox2(strHistory As String, _ ctlTxtBoxName As Control) Select Case strHistory Case "VAC" ctlTxtBoxName = "Vaccine" ...
Thanks John! So nice of you. A.D.Tejpal ... From: John Viescas To: MS_Access_Professionals@yahoogroups.com Sent: Tuesday, March 01, 2005 19:18 Subject: RE:...
Hi John, Thank you v-e-r-y much! a) Made your suggested changes to routine b) and moved routine to public module works nicely! Concept is great for future...
Using a bound form, when a new record is created users need to be able to assign a randomly generated color to the new record. Main Table has CaseID as PK...
John, all seem to be text fields that are null EXCEPT my autonumber ID field I copied these to the immediate window for those that trip the not equal ...
Sandra- The reason you sometimes have to put fields you need to reference in code in a report in hidden text boxes is the report engine "does it's own thing" ...
Hi John, Thx for the explanatiion.....will file away for future reference..... thx again, Sandra John Viescas <JohnV@...> wrote: Sandra- The reason you...
I have an issue when a user opens an access database the first form to open returns an error from the vba code. When I go into debug mode Left ( the Function)...
Thanks for your help. I have several questions. See comments below (in blue). ... wrote: Adam, Out of 2080 records in table named Production, 14 are found to...
Also make sure you are looking in the code view....as both views have the tools tab. Neil Squires ... From: t_hannemann2003 [mailto:mustangcoupe@...] ...
I have gone into the exact same database on my PC and everything works fine. The references look fine in both the users PC and my PC. What is highlighted is...
James, Sometimes it helps to write down all the references, and add them back one at a time until it works. I've had cases where they all looked good, and by...
But the database works fine on every other users pc. Using the exact same database which resides on a network drive (both front end and back end) so would this...
James, I don't have any databases where both FE & BE are on the network drive, so I'm not absolutely sure. My impression is that the references are going to...
When built-in functions do not work, it almost always means that the PC running Access is missing a reference. Just because the front end is on the server, it...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
