Search results

If you want to have a date range as one of your filters you could use the following code. This code uses 4 fields to get the start date and Start Time as well as the End Date and End Time. I use 24 hour Time. The 4 field names are StartDate, StartTime, EndDate, EndTime. I went through a...

I have a command button that opens up two programs and when I am done with the current form and it closes I would like to close both the programs that the button started. I have tried Application.name.quit and variations of that but it doesn't seem to work. Is there a quick way to name the...

Thanks Bob but I just figured it out. I just put behind the button that opens the form to not only set the record source but also to set the focus on the command button. I thought I already tried that but who knows :)

I have tried everything I can think of from: On Open: [Command25].setfocus [forms]![KeywordSearchResults].[command25].setfocus [Forms]![KeywordSearchResults].Section(1).[Command25].setfocus If I could just set the Tab order to start with the Header I could send it right to the button...

I have had a hard time setting the focus on a button when a Form opens if the button is in the Form's Header. I just can't seem to make this work. Your help with this annoying problem is appreicated:)

O.K. I figured that one out. Thank you all for your help but I have another..... I need to run a query on a table that lists multiple records for different individuals. I need to be able to group them by the subject identifying field "FINS" and then count the unique records where their Station...

Guys! At ease! I appreciate both of your points and your passion. I have a question for you Raskew. I have some experience using VBA code in Access but I have never set up a piece of code that is public and can be access anywhere. All of the code I have written has been in one module. I...

I have a table that tracks the purchases of my customers in a table. The Table has the customers id number, date of purchase, and Item. I need to be able to know what they bought the NEXT to last time they came to my store. I can use the date and the max function to get the last purchase but...

ultimate goal: I would like to count the unique subjects where the product purchased is Fish. I have a query that gets a list of subjects where they have bought a certain product. But in this list there are multiple records of certain subjects. I need to ultimately count the unique...

Your problem is that you have a continuous form and you are trying to make formatting changes based on individual records. With a continuous form the field can only have one formatting at a time. Since you are in reality just seeing the same field multiple times it can't display different...

I guess there are two questions. 1.)Is the form that has the login name closed before when you run the sql code? If so then it can't reference the field if the form is closed. To solve this make sure that if you use a docmd.close command put it after you run the append query. I always try and...

You can add this code right before the last End Sub. docmd.setwarnings false docmd.runsql "INSERT INTO YourTable ( [strEmpName] ) SELECT [tblEmployees].[strEmpName] FROM [tblEmployees] WHERE ((([tblEmployees].[strEmpName])='" & Me![strEmpName] & "')); docmd.setwarnings false YourTable = The...

I have been trying to figure out how to play a movie clip I have in an unbound field on a form if you can help please pass on the procudure you have used that works. Thanks for the help, Tyler:)

I know how to use: application.hyperlink "www.juno.com" but what I am having trouble with is getting the focus on the webpage so that I can maneuver to the MemberID and send my name and password on through code. I have tried to use send keys but for some reason it can get to the member ID...

Sorry you explanation is a little difficult to follow. (probably why nobody has replied!) If I understand your dilemma you have a form with a sub form. The main form has the Reservation information and the subform has the client's info. Where I got lost was when you said: "When the user...

I have another way you could password protect a form. If you create an unbound text box that requires a password you could have a command button that requires the proper password to be entered into the box or the button to go to the form is not enabled. Example: (this code would be behind the...

A few thoughts These are a couple of general question to think about. 1.) Do you want to password protect the entire database or just a certain form? If it is just a form than you could use an on open procedure for that form that looks up the users permission level and if it is allowed than...

Ok, I can already do the hard part of starting Outlook and I can even create a new messge using sendkeys "^n". Here is the code I have used so far: Private Sub Label380_Click() MyAppID = Shell("C:\Program Files\Microsoft Office\Office\OFFICE11\Outlook.exe", 1) vartimer = Timer + 4...

Hey DJKarl thanks for the code. I have a question though. My VBA skills are still developing themselves. Can you tell me which part will go on the Form On Open Event Procedure? I am trying to follow your code but I get a little lost. It appears to me that you are defining variables in this...

Thanks but I did a google search and just hiding the task bar isn't what I wanted to do. I just wanted to clean up my database look but still give people the option to bring up the task bar by doing a mouse over. Since I'm not about to go around and set all the computers to autohide the task...