Search results

isnull(form_setup.checkbox)

looks like you're putting single quotes around the number making it a string value instead of a number. Try like Ranman's statement or get rid to the single quotes around the number

public publicVar as integer ' in form The form would need to stay loaded and you'd reference the global variable with form_formname.publicVar

what about something like DELETE [table].[Date Entered] FROM [table] WHERE ((([table].[Date Entered]) In (SELECT Max([table].[Date Entered]) AS [MaxOfDate Entered] FROM [table];)));

Sounds like you'll need a timer in the form which continuously filters the data when the time changes. You could check every 60 seconds to see if the minutes is zero then requery. The query could be dynamically built in VBA so that only the correct time zones are included. If this helps, do you...

Don't bother relinking tables. That doesn't refresh the data within the tables. Assuming that it works the same way for SQL Server that it does with an Access database (may not be a good assumption). If I want my data refreshed within a form (using the sort button on the ribbon), I simply sort...

Guus2005: Thanks for the direction. I'm playing with the Web Browser control and it sure doesn't seem to have the flexibility of the image control (e.g. scroll bars optional, size mode). It also brings in another reference, which may cause problems because of the wide diversity of computers...

Is there some way to have a Picture property of a linked .jpg on a form reference a URL instead of a spot on the hard drive? I'll ultimately want to change the URL in my code depending on which pic to show, but I'd like to get a hard coded example working first. Using Access 2003. thanks, James

The error that displays for the user points back to this function, just not a specific line.

No such luck as the Outlook 2000 system is not mine, but on a computer using my Access database which is delivered as an MDE with no code. I'm not sure but they may not have Access either but using the run-time. It is also several States away.

I'm getting an error sending e-mails using Outlook. It works fine with Outlook 2002, but I'm getting a 438: Object doesn't support this property or method from the Outlook 2000 system. I'm late binding the Outlook object to help remove incompatibility issues. I'm using Outlook so I can send...

Possibility 1 would require you copy the database from site 1 to site 2. To copy a query you'd probably import the query File>Get External Data>Import. Select the site database with the queries you want to import. Choose the Query tab. Select the queries to import and the OK button. Possibilty...

>>DoCmd.OpenForm "Main", , , "[StudyID] =" & "'" & Me![Combo24] & "'" You're specifying a filter, which if a primary key will only return one corresponding record. Navigation buttons will only navigate within records which are returned from the filter. Here is the wizard code which Access...

I'm not really following what you're doing. But I'd set some breakpoints especially on this line "Me.lstReports.RowSource = gstrRowSourceLst" to see what gstrRowSourceLst and gstrRowSource looks like.

I would like to be able to set the FrozenColumns property of a form. But it's read only. What I'm doing is saving and restoring some of the properties of a datasheet subform so that the column changes a user makes will be restored automatically when the form opens. I've done this...

It may have to do with a null value. You can't compare a null value to some other value. Maybe this is not allowing the calculation to work. I notice you are doing some comparisons prior to checking to see if the value is null. I'd try to see if converting a null to -1 or some other value would...

Sounds like your question is with the math, not the displaying of the results. Therefore, the DateAdd() function will let you subtract 2 hours without worrying about crossing a boundary. You may then need to Format() the result to get your military time. James

Are you sure >>If Distance_Feet > 6600 Or Distance_Feet < 8580 Then Frac_Distance = 6600 is what you want. Every # will be either greater than 6600 or less than 8580. Don't you mean 'And' instead of 'Or'. James

I don't understand the error you're getting but the reason >>If me.form.field1 = "test1" or "test2" or "test3" then doesn't work is because you're not telling it what to compare "test2" or "test3" to. It would need to be written as If me.form.field1 = "test1" or me.form.field1 = "test2" or...

When I send an HTML e-mail, I must display the message, for the body to be placed in the email. If I comment out the .display, the body of the email is blank. I'd prefer not to display the message. below is my code. Dim objOutlook As Outlook.Application Dim objMsg As Outlook.MailItem...