Search results for query: *

create a update query and view SQL. From there you'll know how to do.

Pass the form name to the following function. Function will return True if form is open and False if it's not. '****** Code Start ******** Function fIsLoaded(ByVal strFormName As String) As Integer 'Returns a 0 if form is not open or a -1 if Open If SysCmd(acSysCmdGetObjectState, acForm...

Try do not use Forms!form_name.fieldName, use variable. If you want to use form!..., you should add "&" in front and back, like = & Forms!frmReviewerID.cmbMyRole & ...

CraigHartz, I like your function. I am sure that it is working in ADODB, but for dataset, do I need do some change? How to pass?

You may need set up permision for user.

Decalre public variable in form and use them in report section "on format" event.

I only give you idea how to create main data entry form in which there may be one or more combobox. For specialty table and another table which use for combobox, you need create another data entry form. If you need sample, you can download from bellow and study "data entry form&quot...

I just finished the DB like what you want. Here are some idea: 1) you need a function to fill specialty combobox when loading the main form 2) you need a function to get specialty_ID if pass name, this ID is store in vendor, because in combobox, user only see the name. If user change the name...

here you are! http://support.microsoft.com/default.aspx?scid=kb;EN-US;817247

Many way can do it. Here is datareader drSQL: strSQL = "SELECT * FROM tblCustomer" cnSQL = New SqlConnection(ConnectionString) cnSQL.Open() cmSQL = New SqlCommand(strSQL, cnSQL) drSQL = cmSQL.ExecuteReader()...

download samples, run it, find answer from books and forum, you'll learn a lot. Starting data entry case, my .NET experience from there: http://www.microsoft.com/downloads/details.aspx?FamilyID=87951cb9-5aeb-4f46-9bf0-2b3e3664be77&DisplayLang=en

I spend a couple days to solve the same problem. Here is partial code. Use currencymanager to get cell data. I wrote GetcustomerID to get ID from Customer Name. Dim cm As CurrencyManager = CType(Me.BindingContext(grdSearch.DataSource, grdSearch.DataMember), CurrencyManager) ' Retrieve...

VB .NET not support docmd.

Try to use WindowsIdentity.GetCurrent method to retrieve user account. From help, you will get more info.

I think that you need type conversion. Only number type can do the math job.

I got "Object Reference not set to an instance of an object" message sometime. Try load code avove in form_load event.

use sql statement and assign to form's record source. like: strSQL = "SELECT * FROM order" Forms!frmMainForm.frmSubForm.Form.RecordSource = strSQL

Great!!! Today I just fixed my program because I add one field in a table. It cause big trouble in many query. It took about 3 hours to find out and fix queries. Now, I can use it no trouble any more. Thank you again.

I created new app and only form1 in it to test.

download 101 samples from microsoft. There is a sample of how to read and write image file.(binary)