Search results for query: *

Can you translate that into VB.NET? Thanks,

LenardD, What if I just want a default for a bound dropdownlist? Or maybe a default of no entry? Thank you,

I'm very new to this but I think it has to do with the View State of the page.

Bigfoot, may i ask you two questions? Do you have your fields in your database set to allow zero length strings? Thank you,

What they always tell me is to format it in the query prior to binding your grid. Maybe use the IIF(). Good Luck,

I would like to see the gridcode. Thanks.

Sorry Paul, change the # to 0 (zeros)

Try using the Format function on your record source. For example; =Format([SSN],"###-##-####")

Open your query in design view, select Query | Parameters and enter your parameters again in the Query Parameter dialog. Good Luck,

We create Access 2000 applications that run fine on Win 98se, ME (Yuk), 2000, and XP without any problems. Test and see.

What version of Access are you using? Are To_DocuTech and To_DTP the names of controls on a form, a variable, or what? Try this, To_DocuTech must be the name of the control on your form that has the date to be increased by one day. If Isnull(Me.[To_DocuTech]) Then 'DO NOTHING HERE. Else...

Try this, If Isnull(Me.[To_DocuTech]) Then 'DO NOTHING HERE. Else Me.[To_DocuTech] = Me.[To_DTP] + 1 End If

What are you going to do with the information you receive? This can make a difference on how you capture the events. There is no command to know when a filter is applied. You will need to include a boolean variable in your procedure to know if the filter was applied. Something like, Dim...

No one asked what version of Access is being used to create the MDE. You can only create an MDE in the save version format as the mdb file. Access 97 to 97 Access 2000 to 2000 Access 2002 to 2002 Good Luck!

It might be easier to use the HasDate property for a subreport and then use an IIF statement to show on the main report when it opens that there is no data to show. For Example; in a text box on your main report add something like this. You will need to replace my entries with your own...

Yes you can link to the Oracle database tables using ODBC and a DSN connection. Open your Access database then go to File | Get External Data | Link Tables. Make sure to select ODBC as your File of Type. Good Luck,

You can use this code. You will need to create a table to hold the holidays(HoliName) you want to include and the date(HoliDate) they fall on. Public Function DeltaDays(StartDate As Date, EndDate As Date) As Integer 'Get the number of workdays between the given dates Dim dbs As...

Import your text file and click the Advanced button in the lower left of the Import Text Wizard screen. Setup your specs and click the Save As button. Then you can use that specification in your TransferText Code. For Example: DoCmd.TransferText acImportDelim, "Stats3test Import...

If votgop's idea does not work try using Format([Date],"mm/dd/yyyy") or FormatDateTime(Date,2)

Try rebuilding your query, using your form and field names. Put this in the criteria row for each of the field columns the user can search on from your form. [Forms]![frmYourForm]![YourControlName] or [Forms]![frmYourForm]![YourControlName] Is Null Good Luck!