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...
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.
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...
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...
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...
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...
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...
I have a form with a bunch of fields in it, and I'd like to be able to have the user click on a button and have the info from each field on the form automatically get exported/copied into specific fields on a certain web page. Is this possible?
I'm kindof a newbee to access, so if this is trivial sorry. In a form, I have an unbound list based on a query, one of whose fields has a parameter value. On the same form, I have a text box (a date defaulted to the current date that can also be changed manually). That date is the object of...
in a form, i want to create a list whose length isn't static. i have a table field with a bunch of dates, and need to create a list in a form with the number of fields depending on how many dates in the table field have the same day as the current day. thank you much, in advance.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.