Search results

Hello. I'm not very good with lookups, but from a button click I need to check what record ID's are found in a query, and then carry out different actions for each one that is present. The query contains minimum zero records and maximum forty records at all times. I am doing this currently...

Hello. I have an unsplit Access 2003 database. I don't want people to be able to link to its tables or import them into other databases, Excel, etc. I know I could "lock" it with a database password, but I don't want users to have the inconvenience of typing this in whenever they open the...

Hello. Is there any way to have a VB timer event check to see if a message box is open in the database before it runs? I have a switchboard form that is always open in the background and it runs a regular timer event. I've noticed that on other forms, any message box appearing can cause...

Hello I am working on a database and currently have some of the general options set specifically - e.g. windows in taskbar, cursor behaviour when entering a field, etc. If I later distribute the database to other users as a .mde file, will those same option settings be retained for other...

Hello. Is there any way to have the printer dialog box appear when printing a record in form view? If I print the whole form I get the dialog box using: Dim stDocName As String stDocName = "FORMNAME" DoCmd.RunCommand acCmdPrint But the standard code to print a single record doesn't...

Hello. I'm using an unbound text box with a datasource set to =[CurrentRecord] to show the number of the record currently being shown on my form. This has worked on all my forms in the past, but I am having difficulty with it on one particular form. There are 25 records in the underlying table...

Can anyone help please? I have a database that uses pop-up calendar controls on many of its forms. On my computer, the calendars all look normal when they appear. However, a colleague who has started using the database never sees the calendars appear properly. The calendar control pops up...

Hello. I'm having some problems using the Mail Report command button to send a report as an email attachment. It worked perfectly at first when I chose to send the report in snapshot format. However, when I chose Excel as the format it caused the email program (Lotus Notes) to throw an...

Hello. I have spent the last couple of hours looking through the forums but have managed to get myself really confused. Lots of questions, sorry - if anyone can point me in the right direction with one or two of them, I would be hugely grateful! I have a database in a shared folder on the...

Hello. I'm a bit stuck and would appreciate any help. I have a table with a Date / Time field and a field to record Activities on that date. The Date / Time field includes some entries with just the date recorded, and others with date AND time recorded. (This is using UK date format by the...