Search results

Linking to SQL Server? Hello, I'm using 1 table & 1 Form for simplicity in explaining myself. Problem: I have a MSAccess DB with Table1 & Form1 with Table1 as it's record source. I have lets say 100 users with MSAcess (or Runtime) around the U.S. that would have the front end which consist...

I want to do the same thing! Barry, did you figure out how to synchronize the record change with pop-up verses your main form without using a subform? I've been trying to figure this out and I need to figure this issue out before 4 Dec 02. Thanks, Please Reply

I want to do the same thing! Barry, did you figure out how to synchronize the record change with pop-up verses your main form without using a subform? I've been trying to figure this out and I need to figure this issue out before 4 Dec 02. Thanks, Please Reply

The DB is at work. I promised my wife "No computer during this Turkey Day stuff". Basically, I have FormA with many fields amongst the many fields are the [DEPARTMENT] field, and [JOBTITLE] field. [DEPARTMENT] field is a combox used to select your particular [DEPARTMENT] and the [JOBTITLE]...

OK, I have a "EmployeeDataForm" that we input various info in regards to our employees that work in our company. One of these fields is a combo box to which you select the "[DutyPosition]". The "DepartmentSecretaryInfoForm" I've created pops up when the [DutyPosition] field (ComboBox)...

I have Companies A & B. Both companies have lets say fields: [one] & [two]. I know how to use the grouping feature for reports to set either a "Company A Header/Footer" or "Company B Header/Footer" I want to have "Company A" give me a sum for its fields seperate from "Company B's" sums for...

In response to the above. I appreciate you responding but the question is not how to view the SQL version but I asked if there were a way to update table to table with one statement. Sort of a wildcard statement rather than the large SQL statement which makes you annotate each field to update...

I have tbl1LinkTable & tbl2, they have same structure just tbl1LinkTable need to update tbl2. I know how to do this individually but is there an SQL command that allows you to simply use a wildcard to update all fields from one table to the next. I am working on 3 seperate update queries, all...

Re: update query How would I accomplish this with an update query. I tried to use that route. I get the updates from my clients via an export from their table in excel format. I wish to only update specific fields.

Issue: I have 3 fields which all together make up the primary key Lets say I have fields: [A] [B] [C] & [D] fields AB&C make up the primary key. Now, I wish to update the data in field [D] and this record already exist. Is there a way and if so, how would I only update the data that has...

How would I accomplish this Correct me if I'm wrong because I keep having problems: I have "tblMaster" has 3 primary keys (Month, Year, & UIC) which are set as "Yes, no duplicates". Each subordinate company is identified by a "UIC" and they send me via email (excel format) updated reports...

Thanks Ian Thanks!

MY problem is that I have a table in which my primary keys (month, year & their units UIC) are "no-duplicates allowed" of course. My clients would send me their report data on a month to month basis but in the case that they wanted to update a previous months data, how would I import this data...

Try Conditional Statements I'm still a newbie and haven't provided the exact code but how bout: something like - [finishedjobscheckbox] = true then [priority number] = null then have it redo what ever query you had it originally do to assign the priority numbers in the first place. So...

Search by Form I am having difficulty with how to have a Search done by Form that gives the same results as a "Filter by Form" I currently have users simply use a "Filter by Form" and then "Apply Filter" which works just lovely. The only problem is that as you probably know; This feature...

Here is my problem. I have a filter by form that works great. Ex: A user may want to look for all males with a bachelors degree that are under the age of 26. They press a button labeled "Submit Search Criteria" which is basically an "Apply Filter" button. My form is now filled up with only...

My program is self sufficient. You can do everything via my forms (built in buttons) My orginal question is how to get rid of, place behind my form or shrink the gray background frame with the tool bar that's left (File, Edit ect.) appears behind my forms. Something that just hit me was too...

I appreciate everyones response. I have Office XP Developer but I'm not all that of what it is capable of. Does that make any difference in what I'm trying to accomplish? Eforce

Hi, I've went into the Start-up options screen and removed all the checks from checkboxes including in the advance tab. I'm speaking of the window that my program opens up into. It has "File" ect... It's like a frame. Thanks, Danny

I have Office XP Developer and thought that once I created a stand-alone program using it that I wouldn't get the MS Access frame running in the back of my Switchboard. When the user runs my program, I just want my form (switchboard) to pop up not the screen in the back drop (file menu ect..)...