Many times when I write an expression I get the following: Runtime Error 2465 Database can't find the field '|' referred to in your expression. What causes...

I would like to replace tab buttons with command buttons, is this possible?

Tried the below, it didn't work =DateDiff("d",CDate(Nz(,0)),CDate(Nz(,0))) On my form there is a control name Work Date which shows the date the work was...

I created a fom with a list of numeric values. From the list of numeric values, I want to pick out the highest or largest value than multiply it by another...

Hi, I have a database of people around the world that have taken various classes. I have a query called SearchDBQuery with fields that include Name, City,...

I get a compile error: else without if error message from this code. Tried and tried removing ifs and end ifs and all Thens are at the end of the line. Can...

Hello, What file contains the bitmaps that you can use on a form button (picture)? -- Thanks in advance, Steven

I have added a subform. It is based on another form. However when I look at the subform on the main form it is displaying in datasheet view. How can you...

Very quick question.... Is it more efficient to build a form from a query or from the table? I am building a form with a sub form. Should I build my parent...

I have two tables, residents and assessments. one to many relationship. when I use the form wizard I can create a form to look up a resident and then I can...

Hi, I hope that somebody can help me. After setting up proper page setup for form in Access it will print properly once or twice and after that it will set...

Hello All: One quick question. How can I change the default highlight color of a list box? Is there a simple way that I'm overlooking? I'm using a standard...

one of our scientists asked this question, any help greatly appreciated: how can you capture the XY coordinates of the mouse at any given time? We'd like to...

Am teaching myself Access 2003. Please excuse my ignorance. I'm stuck! When I select a 'Style Code # (from a drop down list) on my form called 'Order Entry',...

I am using A2k, and having quite a few scares with database corruption. Making me wonder if access should even be used at all, since once again there is no...

Hi I have an Access database, Invoices.mdb, secured with secured.mdw. In there I have a form, frmInvoice. Each Invoice has a unique key, InvoiceID. These...

I have a main form with 2 subforms. Each subform is linked to the parent via LinkChildFields and LinkMasterFields. Each time I set a value in the Parent...

I have set up an ACCESS database of journal articles. Each article has one or more authors. I have created a form listing the article title, the name of the...

Hello, I have created a form for tracking things. I inserted a drop-down box that offers four options from a value list (no-one, everyone, group,...

I have a query that references the contents of list box similar to below in my query: =!! When click my command button on my form. Instead of running the...