Search results for query: *

Does anybody know the syntax for scanning through a string upon input being entered, checking for an apostrophe character, and replacing it with a ` character? Thanks in advance for any help.

Uhhh...Fairly simple question, I just can't figure it out. I have this for loop where the first line is something along the lines of For Each MyCharacter in Me![MyComboBox].Length Only the Me![MyComboBox].Length is invalid syntax (there's no .length function). What's the correct way to...

I have a form that contains a combo box. the control source of this combo box is a query of companies, and when you choose one it takes you to that record for the form. yada yada, easy peasy. the problem is that one of the companies (so far) contains an apostrophe, so in the after_update code...

The unhide button isn't enabled under window.

i right clicked on a form, clicked hide. now i need it to be visible again but can't figure out how. any ideas? thanks for any help.

I have a form that is in datasheet view with three fields. all three are visible, but i want one of them not to be visible. For some reason it still shows up (in datasheet view at least, but not form view) when the field's visible property is set to No. Thanks in advance for all help.

haha Art, I think you're the first person to figure that out. Since you can't enter the code builder for the control source of a field (that woulda made it easy) I used the IIF function in the expression builder. Thanks for the help.

I have a text box on a form whose control is the sum of two other text boxes on the form. When both source fields contain data, works fine. One of the source fields, however, is based on a Dsum statement that sometimes results in data but usually results in nothing. What's the easiest way to...

Ah, that did it. Thanks Joe.

Yup, #error. But without the Sum() I get a valid value, but just one cell, not the total sum.

Nope, same error as before with the Sum statement. Thanks for takin the time to look tho.

I have this subform which consists of a combo box (based on a query) and another text box (Amount). On my form, the user can choose a billingOptionID from the subform's combo box and the amount for that option shows up in the field next to it. The subform is in datasheet view, because there...

maybe a better way to phrase this would be: is there any way (in general) to open up a query of pages to a specific record?

Eh...I don't know if I explained it right. There's a form and a page based on the same query, each with the same text boxes and everything. So the page and form both have the same number of records with the same info. i put a hyperlink button on the form that opens the page. but no matter what...

Here's Microsoft's site for this problem: http://support.microsoft.com/support/kb/articles/Q242/2/18.ASP?LN=EN-US& I had your same problem and uninstalling only the MS Small Business Tools part of Office fixed it for some reason.

This might be simple. I have a form with 50 records, each containing about 50 fields. I created an html page (in access) based on the same query that the form is based on (with the same 20 fields). When I open the page from the pages section i can scroll through the records, seeing each of the...

This might be simple. I have a form with 50 records, each containing about 50 fields. I created an html page (in access) based on the same query that the form is based on (with the same 20 fields). When I open the page from the pages section i can scroll through the records, seeing each of the...

Well, I have to do this with another link where the site doesn't show you the filled-in-url, even after hitting stop. it automatically jumps to the new url. so i went to the html source code and tried the site followed by ?firstvariableisee=yaddayadda&secondvariable=yaddayadda... and i got...

Thanks John. Good idea, didn't think of it.

I've posted on this before but am still having some problems. I have this form where a user enters a company name into a certain text box, resulting in data on that company to appear in certain other text boxes (e.g. creditcardnumber, creditcardexpmonth, creditcardexpyear, et.). the user then...