Search results

Can be caused by a lot of things but I find the most common cause is users pasting into text and/or memo boxes. Access often can't cope with strange characters pasted in and you end up with corruption. Could this be happening? One other thing - after doing the compact and repair it would be...

Your main problem is the query 'AA Table Query' that has a join to 'Item list Query' which is limiting your Recordset. Remove this table as I cant see that it's needed. Then in design view of your Main Form for your 'Find..' button change the Macro to an [Event Procedure] on the OnClick and...

Just tried running through this and it produced an output text file with 240 lines with the following repeated: Amend;111111 Amend;222222 Amend;333333 Amend;444444 Amend;555555 ..etc I am using Access 2010 on Windows 7.

Archn00b What happens if you take the True out? Also is True written without quotes in your query?

Robinson, In a new column in the query in the field box put the following: Price: iif([ColumnStye]="Wide", .15 * [ColumnLength],0) What happens though if the column style is not 'Wide'? With the line above the proce will be 0.

Have you removed the other criteria?

Remove the criteria you have set in the query and in a new column place the following in the field box: IIf([forms]![Find_Member]![Alderney_Only] = Yes,[ID]="92",[ID] Like "*" Or IsNull([ID])) Now in the Criteria box for this new column add True NB: You need to replace ID with the name of...

1. Yes 2. Yes - You need to reference the form like this: Forms!FormName!ControlName

If the welder field was a combobox then you could just have all the required data as columns and then they are there to test with whenever you need them.

You need to loop through the recordset so the code would look something like this: If Not Len(Nz(Forms![frmdtp/ctp].Form!frm_cyfra!ID_cyfra)) = 0 Then with Me!frm_cyfra.form.recordsetclone if .recordcount <> 0 then .movefirst do until .eof .edit !Id_Pracownicy = Me!Imie...

Ok, my advice would've been to try it in 2010 because I've seen some sketchy things using earlier versions but seeing you are already using 2010 I don't have any further advice. Sorry. Though I would add that that is one large database and if it were me I'd probably try and reduce the number of...

The Runtime version will run the database just as the full version does only there will be limited functionality. With regards to splitting the database this is highly recommended. After this you will need to either distribute users with their own front end or give them a link to a shared front...

Try this: Me.[FIELD_TO_CHANGE] = DLookup("[FIELD_TO_CHANGE]", "tb_TABLE", "[ID]=" & Forms![form_FORM]![ID] -1)

Think you'd need to add a line at the top of the report and at the bottom and then in the detail have a 'growing' line - http://support.microsoft.com/kb/170838

What version of Access are you running?

Try adding the following: Like "*" & [Forms]![SearchF]![Firstname] & "*" or Is Null

Check this out: http://support.microsoft.com/kb/170838

When you are calling the function you must send it the required parameter(s) in this case a Long value (sUser). So, the call would look something like this: call LogMeOff(15) NB: 15 is a made up number but this would be your PKEnginnerID. FYI: A function is normally used to return a value so...

Hi CJ, I have worked with Citrix a little and have found that Access works pretty much the same as if it were on a remote server with a shared front end i.e. each user has their own 'instance' of the front end so changing things like the record source would be specific to that user. As far as...

So just to confirm you have typed 0000 into the format property for that control with no quotes?