Search results

Right-Click on the Report at the Database window level i.e. not opened, and select Create Shortcut. This automatically places the Shortcut inc handy Report Icon on your desktop. Diribute the shortcut to your users.

Sequential Record Selection MartijnR, Thank for your reply and sorry for not getting back sooner. I am not convinced that normal use of record locking will work for me. All, I have done my testing without the Next Record feature and I'm back on it. To expand a little, I would like the users...

Hi, You need to remove the last close bracket ')' You also may want to make the code a little easier to read rather than it running into the PC to your right. strSQL = "" strSQL = strSQL & "SELECT tblSAPBookings.[Sales Rep], tblSAPBookings.[Sales ID], " strSQL = strSQL & "tblSAPBookings.[End...

Please can you provide the code you are using currently?

See if an answer I have just provided fits your bill: http://www.access-programmers.co.uk/forums/showthread.php?t=104067 This is a method I use to pass a String variable to a function trapping null values. You can use the: GetCOMBOVal() in my example as the criteria for your QueryDef.

Have a look at: http://www.utteraccess.com/forums/access/access268573.html Should help you. You need to realise with Access you don't need to optional Holidays Argument as an input. I had trouble with this logic for ages.

The easiest way is: Criteria: Forms![YOURFORMNAME]![cboYOURCOMBONAME] But not the best way. I don't like to bind queries to forms. I prefer to create a function to pass the control value to on an event. Public COMBOval As String Public Sub SetCOMBOval(myCOMBO As Variant) If...

It may happen often. But we are moving to Access 2003 in a month, that's when I can down right funky with the developement with no A97 limitations. Cheers,

I can't see what wrong with the last one: Select DISTINCT SCREEN_ADD_PRODUCT.STK_PART_CODE , STK_PART_CODE_DESCRIPTION ” &_ You need to set the Combobox 'Column Count' to 2 for it to be viewed. It is a better method than concatenating the strings as you will end up with: 1001 - This One 23 -...

Excellent, I'm using Access 97 so I've had to use the Replace97 Function. I already had a similar function but didn't think to use ´ I also can't find that character on the keyboard, so the finished artical ends up as: Public Function Remove(s As String) Remove = Replace97(s, "'", Chr(180))...

I'm not usally one for bumping up messages, but can anyone hep with this as I'm in a sqeeze. Cheers,

All, I have the following code to insert records into temporary tables on the client. DoCmd.RunSQL "DELETE * FROM tblTEMPNTCChild;" strSQL = "" strSQL = "SELECT tblNTCChild.NTCChildID, " strSQL = strSQL & "[1stForename], " strSQL = strSQL & "[2ndForename], " strSQL = strSQL & "Surname, "...

=SUMPRODUCT(($B$2:$B$6000=601)*($G$2:$G$6000="Claim")) Hope that helps

All, Bottom line I'm in bit of a pickle, work has moved forward the migration of Office97/NT4 to Office2003/XP by 2 months (clever lot) and was hoping not have to cram for this question until at least 3-5 weeks. I'm looking for pointers/suggestions because I now have to test in Access2003...

You say it has the 1st 6 entries checked, what are they and do any of them have 'missing:' in front, I'm guessing not as you haven't mentioned it. I'm bst qualified at VBA in Access, but it seems Str() isn't part of 2003 which I have on this machine. You can use Format() Again not qualified...

Add a table to the network side where when a user synchronzises it adds a tick in a box and removes it when they have finished. When person 2 trys it, stop them at the tick. I'm sure you have your reason to have several users with local copies of the DB but it doesn't seem logical to me at...

It can't be very hidden: A B C E F will get spotted anyway. However you can 'not show' row & column headers (I'm not a fan of this) and protect the sheet. Not great because the user can just show the headers if needed You can also just put the data onto a Very Hidden Sheet.

It shouldn't make a difference as long as the field isn't related to any other tables. Add it in design view. You will have to add it to any Queries/Forms/Reports?VBA etc. which need it.

Of course, I wrote it out freehand, that's my excuse. Anyway, 44 yes but not all need to be done each time. It is more the bind of have to write Query1, 2, 3 on all of the fields. Nevermind, it will be easier than my method. I wonder if someone has created a mini application for compiling a...

Thanks Jon, My problem is the amount of fields in the real data 44!!!! I can't test until tomorrow but would something like: UPDATE tblApplicantAddressTelo INNER JOIN tblApplicant ON Nz(tblApplicantAddressTelo.Field1,"Null") = Nz(tblApplicant.Field1,"Null") AND...