Search results

Hi Mikael, You will need to install Developer Extention on your PC to package your application that will install Access Runtime on each PC. If you are using A2003 then you have to pay for this and it is expensive because you have to buy somthing Like "Visual studio 2005" I believe the...

Hi, Try this, its not tested but it should work. Dim textstring As String Dim teststring As String For X = 1 To 10 textstring = "textpart" & X teststring = "test" & X Reports("rptTest").Controls(textstring)= Teststring Next X Let me know Garry

Although the on click event for the calendar is not visible in the property list it will still work in the VBA code try this Private Sub MyCal_click() 'Clicking the Calendar Buttons calls this Code. 'Your Code goes here End Sub The name of the calendar in this example is called MyCal Garry

Matt, You might have missed a step, Keith has posted it as a MDB file. It works in A2003 Garry

I Like the example Keith has posted, Also..... If Modal is set to "yes" on the first form and the "Shift Bypass" disabled this has the desired effect. None of the alternative ways of closeing the application has an effect (Access 2003) Not tested it on 2007 Garry

Hi Roy, If you have users that will go to that extent instead of clicking a large “Exit” button then yes you do need to use the example you posted. Or Chop there fingers off :) I would consider that to be sabotage in which case why not just use the "Three-finger-salute" as you put it...

Here is an example. Modal is set to "yes" and the Min, Max, control set to No. These do absolutely nothing on my PC, so it forces the user to close via the "Exit" Button. (Ctrl+Alt+Del) will still close the application. Garry

If I understand you request correctly try... Me.Fieldname = Me.Fieldname & Date Garry

Hi Detrie, If the first form you open has popup set as "yes" and disable the MIN, MAX etc on that form it might get you what you want, If that is not what you are looking for then you will need to hide/minimize the Access application itself, use ... Call fAccessWindow("Minimize", False...

I believe this is a recognised auto key, let me check..... It works in excel and access. It will put the date in for you. Garry

If your boss doesn't mind changing his mind or if you can change it for him use:--- CTRL+; Control key and semicolon all together. Garry

Hi Andy, If Post up your 2 tables we can have a play around with them a try to come up with a solution for you. Garry

If the query is for a report it is automaticly Snapshot, If you are viewing the data in form view the Snapshot/Dynaset can be set on the Data tab of the form properties.

Thanx for the example Chris, It took me a couple of attempts but I nailed it in the end, here is my working example using your first sugestion with some alterations. Sub SetMouseMove() Dim ctl As Control Dim ControlName As String With CurrentDb.OpenRecordset("SELECT Name FROM...

Hey Chris, That worked like a dream, I was focusing on trying to create an event procedure for it instead of just calling the module straight out. Great!!!!!!!! Just to satisfy my own curiosity, is it possible to create an actual event producure in a simillar manner as you have demonstrated...

Cheers Chris, But its just like the post says, I have just picked up a DB that a client wants a face lift on. One of the changes she wants is something she has seen on other applications which is that the cursor turns into a hand when over a command button. "Not a problem" However, I am...

Hi, If you are not editing any of the records from your query and only viewing them then try setting the Recordset Type to Snapshot instead of Dynaset. If this works then when you wish to edit one of these records run the query again using dynaset and ID of the record you want to edit, but...

Hi All, I am looking for help to create some code that will run through an application and add an Event VBA code for every command button found. The code I wish to add is identical for each Command button. I've never done this before, so am not sure where to start. Could someone please point...

Hi Mat, Do a search for "relink access tables" by a guy called Dev Ashish. Garry

Hi Mark, To achieve what you are looking for will probably need a little VBA coding, I dont have the time at the moment but might find time to play with it tonight or tomorrow. You might be better off starting a new thread asking for assistance with "Round up Time" Garry