Search results

My apologies for sounding ignorant, but I still have no idea what you're talking about... Perhaps you could post an example?

No worries ;)

What's a rolling calendar?

set the validation rule on the table field to: Like "???????"

Quick question regarding Hyperlinks. On a form, if you don't want to be able to select or highlight a textbox, you set the disabled property to true. I have a couple of textboxes, with some fairly long strings, that I require as a hyperlink to open a form. I can't set the disabled propery to...

I think I understand..... You can't do it directly, however, you can add a "User Input" cell next to the calculating cell... Then use an IF function to determine whether or not a user has entered any data into the input cell. You could do it via VBA as well, however I like to stay clear of...

Oh sorry! I read the problem wrong.... I overlooked the bit that you said there was a Userform with TabPages. I thought it was the page tabs of the excel sheets! Again, my apologies.

I couldn't tell you off hand right now... But from memory it's something like.... Sheets("DefaultDataPage").EmployeeNameBox.SetFocus Something like that. Excel has a fairly extensive help library for VBA. And if all else fails, record a macro and have a look at the code it generates.

example A1: This is some text A2: some A3: =IF(ISERROR(SEARCH(A2,A1)),"Not Found",A2) The cell A3 will return "some". If the value in A2 can't be found, then A3 will return "Not Found". You can change that to whatever you want.

You can still have multiple values in the NAME column, however you need to reference a UNIQUE identity for each row. Right now, you are refering to the NAME. You need to add another column, that has a unique ID, that isolates that row from all the others.

Instead of referring to the NAME in the expression, refer to the Indexed ID of the person. An indexed ID only allows unique values.

Again, you may be best off doing this in an 'evaluation' column. It makes life a lot more simple. It would look like this: =IF(AND(COUNTIF(C1:C65535,"*jon*")=1,F1:F65535="good"),1,0) Then at the top of the column (or anywhere else) Use a =SUM(EvaluationColumn) to count the cells returning 1...

Brian, the new function is SUMIFS It's the way forward.

Sorted! I removed the inverted commas from the [ID] in the expression. Duh.

Hi. I am having an issue with using a DCOUNT expression in a query. I am compiling an inventory, and trying to use a query to determine whether or not, a particular item has been used. I have 2 tables for this example: tblDeliveryItems (the complete list of items) and tblBHAItems (a table...

Perfect. Thanks very much khawar!

You need to add 2 new expression columns to the form VAT: Cost * Tax Rate Total: Cost + [VAT] Then add a total to the Cost, VAT and Total field columns, and link them to your 3 corresponding text boxes.

Hi. I'm having a problem, that I hope someone can help me sort. I'm trying to avoid the use of VBA of possible, and just rely on the native macro functions of Access. (I'm using 2007) If I have a query, or a form's datasource that looks like so.... tbl.ID tbl.Name tbl.Age 1...

Sure. When your user logs in, he/she must click 'something' to login. In that control's events macro 'On Click', add a SetTempVar action to the macro, AFTER the login stuff you already have executes. Call the SetTempVar something like "UserID" and set the expression to refer to the Member's...

I assume you have the tblInventory and tblOffences linked to tblSuspects in the database relationships. You would load a report from another form, using the Where Condition ="[ID]="&tblSuspects[ID] You make sure that the report has the tblSuspects.ID as the first field in the report...