would anyone know why this doesnt work? strWhere = strWhere & "( = not null AND = null) and " it's a line from a filter i've created...the rest work but i...

I have posted a few messages to this board but never seem to be able to find my post later on and/or view responses. This is a test post to see if there is...

Is is possible to freeze columns when you are on a pivot form? Thanks

Hello, Is it possible to use a command button in a form to 1. Run A query, and 2. Export the Query to an Excel file always saved in the same location and...

I have a field that was copied and pasted into an access database. This field needs to be separated into separate fields, which are separated by commas. I...

I am new to access and databases in general, so forgive me if my questions seem elementary. I would like to create a form with a series of check boxes for...

I have a combo box that lists names of queries. Based on this combo box, I would like a text box to give me it's corresponding code. ie: query name is...

Is there a way to suppress this display when data is not yet available to a textbox? This shows prior to the user selecting a client and looks...

I cannot make the focus of the form stay the same... I have many pieces of equipment to attach to one technician... Every time I enter a piece of...

Hi, I am fairly new at using access and have been given the task of coming up with a timekeeping database for a large company. I have a daily timesheet in...

Hi All - my turn to ASK a question. I have an application in which some of the forms contain a subform in datasheet view. It is set up so that users can...

I have a data entry form with a command button to open another form to enter comments. The form opens as I programmed it with the matching customer ID;...

Hey All, I have Me.Refresh in two places, the first example works but second does not and unless I rem it out the code won't compile. Can someone tell me...

Hi experts, I have a form based on table1. By selecting the ProjNum from a combo box on this form, I need to add the selected ProjNum to another table...

I want to create a single calendar each month that shows only Monday, Tuesday, Wednesday, Thursday, and Friday. I want a template without weekends. I...

Hello: I want to make a copy of the structure of an existing database. This database have linked tables and when i want to import the database without the...

i hav a field which is in subform. i'm named it as location. when user change the location and i want to know and i want the record to keep it in a table. i...

I made changes to a form on a copied version of my database, then deleted the form from the original db and copied the new form back to the original db. It...

I am using the below code to send a email. I currently change the default of the email to HTML and copy and paste the content of the subform in the body of...

Hi, how can I make sure input in a text box would be like following: xxxx/nn where xxxx is a number and its number of digits (one digit or more) may vary and...