Search results

How do you get the cursor to the first subform field? I assume it's in VBA; if that's the case, from what event(s) is the positioning code called?

Using my iPad now and it seems OK. Shame about the frame on the right of the screen,though - it takes a lot of my small screen space and I have finger-trouble with it which means I navigate to places I don't want at times. But then that's no change from before.

That's a lot of ANDs in your query! Picking out the first test from the WHERE phrases:(TBL_customer.Photo1Register)=Nz([TBL_customer].[Photo1Register],0)... I am puzzled by the logic here. The same field is present on both sides of the test, one with Nz + square brackets and one without. What...

Go for it!:) These get in the way once you've seen them once, so you have my vote. Maybe you could have a section just for these SPs - some don't qualiy as FAQ (IMHO).

Hi Jon All good reasons! In terms of the width of posts, I agree with your logic for the main text, but for code windows, it may have the reverse effect? Having said that, if I need to read code from any posts, I generally copy it to a VBA module to study it - so perhaps a moot point...

Something like this should do what you want. I wrote this for a dummy table named tSales with fields stDate, stBlack and stWhite to represent the structure you described, so you must substitute your table and field names. Public Function calculateAverage(ByVal pStartDate As Date, ByVal pEndDate...

Is there any reason you can't exclude the records with empty fields from the query? If it's a single field you are counting, then a WHERE clause in the query would do it - but if multiple fields per record, where some have values and others don't, then VBA maybe the only solution. I'm assuming...

Not without precedent from a country which elected an actor as its president - and look at California! Czechoslovakia elected a playwright as its president, so you could say there's a parallel there somewhere. I'll try - but it takes a lot of effort:D. Actually, I've been to Minnesota (if...

OK, we'll agree to disagree on this point. Besides, I'd hate to be held responsible for any droopy garments.:o By Switchboard, I assume you are referring to the built-in Access Switchboard manager? I'm not aware of any limitations on the number of command buttons, but you may be right. I used...

This should do what you need.Private Sub fixCharacters() Dim rst As Recordset, fld As Field Dim varCharsIn As Variant, varCharsOut As Variant Dim strSplit() As String Dim i As Integer Rem set up an array of characters to be replaced varCharsIn = Array("è", "§") Rem set up array of replacement...

I would have thought a bit of knitting would help thinking at work - not enough of that goes on!:D A very sexist comment, if I may say so? What makes you think that mere males can't knit? As a matter of fact, I did learn to knit at school - more years ago than I care to admit.:) Anyway, to...

Does every column shown have a formula? It looks like the left-hand columns are simply showing null fields as blank? Is there a specific column to which your question relates, or is it all of them?

Presumably you have a table of user names? Why not add your units field to that table, then show the checkbox on the user's 'home' form only when it hasn't been set? You would need to allow three values in this field - 'not set', 'use Centimetres' and 'use Inches'. I would consider using radio...

I'm not sure what your queries are telling me here!:confused: Some questions: 1. Why do you use DISTINCT in all of your queries? Do the tables have duplicate data (if so, why?)? 2. Is there a reason not to use the table key as the bound column for the combo boxes? For example, where you have I...

Yes, a macro can be written for your situation! The method of implementation should change from what you have at present, because it is not necessary to copy data between cells in order to carry out calculations. I would put the algorithm into code for each of the result categories so each...

The relationships diagram shows the key on emp_tbl is Employee, not EmployeeID - this doesn't seem right? I need to see the query string for search_frm_qry in order to attempt an answer to your question. What do the combo boxes have as their row source?

Hard to do in plain English when dealing with technical stuff - but here goes!:) Firstly, some assumptions: 1. Each worksheet of all workbooks has an identical layout (given) 2. Each worksheet has a headings row which is in row 1 only (i.e. not multiple heading rows) 3. You want to do this...

One way of doing what you want is in VBA. I have updated your spreadsheet to show how this is done. Look at the code behind 'Sheet1', which is reproduced herePrivate Sub Worksheet_Change(ByVal Target As Range) Dim cl As Range Rem determine whether a change in the 'load' cell brought us here If...

Another method is SELECT Right(MainWrkctr, Len(MainWrkctr) - InStr(1, MainWrkctr, "/")) AS ShortWrkctr FROM tt;

On a continuous form, you are essentially showing the same form multiple times, so the behaviour you see is "works as designed". The only solution I can think of is to have a text field which you can format as you need before the display (in other words, an additional field in your data set...