Recent content by eforce

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