Search results for query: *

Hi everyone. This is a very easy question ( or so it seems ). Here is a short piece of code: #include <stdio.h> int main() { int Phase = 3; double kva = 1000; if( kva > (1000 * (Phase / 3.0)) ) printf(&quot;greater than&quot;); else printf(&quot;less than&quot;); return...

Hello, I am trying to switch from a database running on the JET engine to one that uses MSDE. However, I am having some difficulties getting the sample database NORTHWINDCS to work. I have two computers both with WIN XP PRO installed. Let's say my computer is named A and the remote computer is...

Hello, I have the following code and I was wondering if it could be reduced Private Sub Form_Load() On Error GoTo form_load_err Dim rs As Recordset Set rs = CurrentDb.OpenRecordset(&quot;select * from [core surplus]&quot;) prefix0 = rs(&quot;drawing # prefix&quot;) rs.MoveNext prefix1 =...

I have the following Set rs = CurrentDb.OpenRecordset(&quot;SELECT [DRAWING NUMBER] FROM CORE WHERE [DRAWING # PREFIX]=&quot; & &quot;&quot; & Me!prefix2 & &quot;&quot;) It gives the error: --- Run-time error '3075' Syntax error (missing operator) in query expression '[DRAWING #...

Ok, the following code checks to see if a record exists in the ORDER table, and if it doesn't it adds it to the table. It uses an ADO implementation. Now, the problem is, it takes a while before the ORDER table is updated with the new entry. I was thinking that the table would be updated...

When I try to open the form, it gives me the error: &quot;The connection cannot be used to perform this operation. It is either closed or invalid in this context.&quot; Here is the code for the On_Load event for the form: Private Sub Form_Load() On Error GoTo Form_Load_Err Dim CurConn...

I have the following code that works perfectly when compiled in 16-bit. When it is compiled in 32-bit, there is no response when a particular menu option is selected. The code looks something like this: //this part doesn't seem get executed, probably because the //program is confused by WPARAM...

I have the following code that works perfectly when compiled in 16-bit. When it is compiled in 32-bit, there is no response for a particular menu option. The code looks something like this: //this part doesn't seem get executed, probably because the //program is confused by WPARAM, LPARAM...

Hi, I have two tables ( each with about 200 fields ) that are related to each other through the primary key. Basically, combining all the fields of corresponding rows of these two tables constitutes a complete record (complete record has about 400 fields). Now, I want to display all the...

Does anyone know how to clear the FILTER property field under the DATA tab for REPORTS using VBA? I have a report that can be accessed through the switchboard or is automatically opened when a particular form is closed. The problem is that when the report is accessd through the switchboard...

I was wondering if there is any way to do this... I want to have an option group with four options 1) 4 Pole 2) 8 Pole 3) 12 Pole 4) 16 Pole The option group is bound to a table. When an option is clicked, it will display the corresponding value in the field of the table. How would I do this...

Hello. I have a button that imports a text file into the table. I have set the on click() property of the button as follows. Private Sub Command34_Click() On Error GoTo Err_Command34_click DoCmd.TransferText , &quot;WSPR Import Specification&quot;, &quot;WSPECS&quot...

I have a switchboard that displays several buttons. One of the buttons is Import. When that button is clicked, it performs a macro which imports one record into the table WSPECS from a text file. Now, on the main switchboard, there are two fields bound to WSPECS: QUOTE NUMBER and ITEM NUMBER...

How would i do this. I have a form with a select query as the record source. Each record in the query is differentiated from the other records by the

I was wondering how I would make sure all the fields are filled in... right now i am trying to make an order checklist form. so there is a checkbox beside each item. if the checkbox is selected, then the corresponding field must be filled in. i read another post which had a similar problem and...