Search results

Two options: 1) Put the headings in the PageHeader section (not the ReportHeader section). 2) Put the headings in a GroupHeader (depending on your grouping) and set the RepeatSection property for the Header to "Yes".

You can't have an unbound control that simultaneously shows different things for different records. You'd need the ControlSource for your box to be bound to something - a field, or a function that calls a field as a parameter - in order for it to display different things for each record.

Oops, sorry, should be: objxls.DisplayAlerts = False

So the control you are changing needs an AfterUpdate event, in which your date control is set to Now() (or Date(), whichever you need). So you want something like: Private Sub OtherCtrlName_AfterUpdate() Me!DateCtrlName = Now() End Sub And make sure in the properties box for...

Try turning the warnings off, but make sure you turn them back on again. Note, this won't work for all warning messages. Application.DisplayAlerts = False objWrkBk.Close SaveChanges:=True Application.DisplayAlerts = True

Bit of a guess this, but how about if you leave the table that has this requirement in a different database and then link the table into your new, combined database. You can use your current locking method on the one file but users will get to it from your main database. I think the locking...

Not something I've tried myself, but it would help if you showed the code that opens the file. At a guess, you need to make sure you set the button's HyperlinkAddress="" once you no longer want it to be a hyperlink.

Glad I could help :-)

Is [Job Date] a numeric field? If not then your FindFirst needs changing; the problem is the Find isn't finding the record but it does exist. If [Job Date] is in fact a date then I think you need: rs.FindFirst "[Job Date]=#" & Format(Me![JD], "m/d/yy") & "#" If it is a string instead you...

Or alternatively, varRowState = Not varRowState

Have you tried setting your dates as proper parameters? I don't know my way around Access 2007, but in 2003 you go on the menu bar to Query, Parameters, then enter the names and set the types. I *think* this will stop it asking for the same dates multiple times, allowing you to use your...

The way Access usually sends you to a specified record is using bookmarks and the RecordsetClone. 1) Identify the record you want to go to. 2) Find it in the RecordsetClone. 3) Match the form to the RecordsetClone. The code you need is: With Me.RecordsetClone .FindFirst "RecordID=" & the...

Excellent, glad you got it to work :-)

So you choose a month. Set it up so that this automatically returns the first day of that month. Now you want to build your query with the criteria that: StartDate < DateAdd("m", 1, ChosenDate) AND EndDate >= ChosenDate So you find people who's start date is before the end of the month...

If you right click on the form, one of the options should be Tab Order. Click on this and you get a pop-up window showing a list of your controls in their current order. Drag the control names up and down the list until they're in the order you want.

You could open the recordset in code, see if there are any records, and then only open the form if there are. Firstly, if the form just looks directly at a table then that's fine. If it doesn't (which I suspect is true as there must be some filtering happening here), then you need to make sure...

Excellent, glad I could help and that you found a way to make it work.

After a person has logged in, how do you know what username they used to log in with? This is going to be important. My best suggestion without more info is that you store the user status that goes with their login in a public variable, as follows... Create a module. In the module add the...

From Access 2000 onwards you cannot have more than one user editing the design of the database at one time. This means that you should be OK if people or logging in and just viewing/adding/editing records, but as soon as one user goes into an object in design view or looks at the VB code...

Are you using the built-in security features of Access? If so you should just be able to change the permissions for the users/groups. If not, then you need to save somewhere what username your user has logged in as. Then in the OnOpen event of the form you can set the AllowEdits...