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

Alex, I'm trying to do what you've already accomplished. I want to take info from MS Access Form and basically place it on my MS Outlook Calendar. Firstly, I have an ASP web form with a MYSQL backend that takes reservation request for the use of our facility. I have my MS Access DB linked to...

How would I set a temp table dynamically for each user? Thanks, Eforce!

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

Thanks Cross, You helped me out alot. I finally got it to working. Eforce.

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

Did you figure this out yet I'm also trying to figure out how to use a form fields data in a stored procedure. Eforce

Thanks for responding but I've read much about people saying use stored procedures but what the crap is it and what is the syntax. I'm new to sql but a fast learner. Is it a sql statement that is called like a function in a module? thanks, E-force

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

Thanks Wayne, what I did was create a macro using the RunSQL command and then I converted it into a module, then I copy the code to the close event of my pop-up form Eforce

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

Thanks Pat, But how would I "add record", "edit record" ect.. if the form is bound to a query that fetches records from the table rather than the table that I want to add, delete, or edit to?. Eforce

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

Hey & thanks for responding so quickly, I know what splitting the db is and I know what upsizing does. What do I do with my split db (backend) and upsized db? How do I use my front end to access the back end? I want to know this step by step. I would also like to use the MSDE as the server...