Search results

Is it possible to change the colour of the background of specific fields on a datasheet form? The background colour option doesn't do anything when running the form. If it's not possible, are there any viable alternatives? I'd like to keep the datasheet.

when I meant "null" i knew about requiring 'is null'.

Sorry, I'm somewhat new to this, what do you mean by Nz()?

Hey guys, I'm doing a pretty basic query that Selects about 5 fields From Table1 Where (value=0 AND name <> HOT) OR (value=Null AND name <>HOT) I also have some records (4 specifically) that have a name = nullvalue. When I run this query it picks out all the records with a name, and skips...

How would I implement Rich Text control?

Hey there, I'm writing a module that will write the name of a control to a memo area and the current value, so it will look like "tbText1: HELLO WORLD" How can I make the tbText1 bold? Does a memo box support different font types?

Thanks, that is great! Is it also possible to see which machine has a DB open if you cannot open the mdb file exclusively?

Hey guys, Instead of returning the value CurrentUser, is there anyway to return the name of the computer?

Thanks for the help, but I can't seem to get this working. What does the Me refer to?

Hello, I have a form that has two fields that pull data from two tables, however, in the data source control, I can only see the fields from one of the tables. Is there a way to link the text box to a field from another table?

Hey guys, Is there a way to timestamp each entry on a memo field on a form when it has been changed?

Hey guys, I'm in need of some help again. I have two tables, Table1 and Table2. I have one field in each table that I want to have the same data. I don't want blanks to be merged, but I want all the data to be the same for example Table1 --------- 1...

I would keep it in one table, but I want to be able to easily export only the secondary table . I guess I could do a create Table query, but another reason was because I also wanted a form to access the secondary table. I'm not too sure if I'm on the right plane of thought, there may be an...

Hey guys, I have two tables that share a common field. Is there a way to allow Access to update both at the same time? If I change one in Table1 it does not automatically update the same field in Table2. Is this possible?

I think I followed all the steps correctly, but I can't get it to work with my DB. My error message is something to the extent of "Invalid Outside Procedure". Anyone have an answer to this?

Anybody know?

Hey there, I have created a tabular style DAP using the page wizard before. I used to have the option, but now I only seem to have columnar style. Is there an option I have to select somewhere?

Thanks again! You've both been good help!

Thanks for the help, I've figured this out in the meantime. Now what I need to know is how to allow the user to see the forms but hide the tables. In the startup options, I have the option of only selecting one form. Anyone have an answer to this? I would like them to select from a list of forms...

Hey guys, Is there a setting that will allow me to make specific fields in my table read-only unless I enter a password, or I am the DB administrator?