Search results

Can anyone tell me how to take a report that is exported to XML and link it to a MS SQL Server database? Where in the XML page would I set the data source? Initially I thought the "Live Data" option would create an xml document that links to the MS SQL Server but then I realized that the...

creating and naming dynamic table based on variable Hello All, Was wondering if you could help me out. I need to know how I can have a table be dynamically created based on a variable like the usernID. I looked into the make table query, and went into the SQL view but couldn't figure out how...

I have this code behind a delete current record cmdbutton: DoCmd.RunSQL "Delete from tblMinistryII Where recid = " & Forms![MINISTRY I & II FORM]!RECID & ";" When I press this button I keep getting a parameter box that pops up. I want to delete the current record in my form. The RECID in my...

Hello, I'm working on a java database application in which users can input information via the form to be stored into my database. When the application is opened the form is populated with the data from my database. My problem lies within the fact that I don't know what code to use to have data...

Hello, I'm working on a Java DB application and I'm having a problem with this SQL statement when using the "Or","|", or "||" operators. Here is my code: Data1.setRecordSource("SELECT * FROM tblUnit WHERE (MACOM) OR (DIVISION + MACOM) OR (CORPS + MACOM) OR (INSTALLATION) OR (BRIGADE +...

I'm planning on migrating my application to java and so I'm attempting to create my own security (user/pass) form with MS Access to sort of simulate the workgroup security. Ok, I have a table I call "tblSecurity" with two fields (user & password) I've created an unbound form that accepts the...

Hello All, I have created a database application in MS Access 2002. I have upsized it's tables so that now they reside on a SQL server. My plans for deploying this application is on a Citrix server (Metaframe XPE). All my queries are Access pass-thru select queries. This will be a...

Can anyone tell me how to use the "DoCmd.SQLRun" statement with this SQLView statement. I've searched through help as well as this forum. When I thought the answer was coming while reading through a thread; the poster said never mind he/she figured it out (I hate when that happens) (SMILE)...

I've read through many posts that talk about using the "AllowEdits" function but I've tried this function and cannot seem to find a solution. I have a mainform with a field labled "Duty Position" which is a combo box. When a specific job position is selected I have a small form which pops up...

Hello All, Here is my issue: I've upsized my Access database to SQL and thus I'm using the link table thingy. I have my form's record source is based on a access query. My access query uses a "WHERE" clause which is based on a form's field. This works fine in access but when I tried to use...

Does anyone know how I can limit what a person has to select from based on their username. I have the combo box linked to a query "qryDeptName". I know how to limit the records a person sees based on their username but the combo boxes on the form allows for that same person to choose what...

What is the syntax to use on an "cmdUpdate" button if I want the data that was entered on a form with unbound fields to post to a specific table. I'm told that i should never use a table as the direct record source from a form but I am having problems doing this any other way. Its a data entry...

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

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

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

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

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

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

I've created a program in Access in which the user is confronted with a Switchboard form with 6 buttons which access seperate accounts. I am currently using the security wizard to inhibit users from getting access to others sections but I now want to create a stand-alone version (user doesn't...