Search results

I am using Access 2003 and need a piece of code that will close an externally running program. I use a Shell command to open the program but I can't find any help on closing or killing an external program to Access. You help is greatly appreciated Tyler

I have a table that is imported from a file using code I didn't write. The Table Structure uses text fields, but the values are numbers(Commodity prices). Is there a way that I can convert the fields to number or do some sort of make table query to put the values into number fields? I am...

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...

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:)

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...

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...

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...

I would like to have this code run on database open and then set it back to locked when the database closes. I don't think that I will be able to make any registry changes so if this can be done with VBA that would be great. Thanks for your help, Tyler:)

I have two separate databases. I need to be able to open database 2 using a criteria of a field on a form from Database 1. I have successfully used the shell command to actually open database 2 but I can't get the correct form with filtered information to open. I have used the following code...

I have a number field that has three groups of 3 numbers: 123 456 789 or 12 345 678 (8 numbers). When there are only 8 numbers I need to have the first group of number contain 2 numbers and the other two groups to have the other six numbers. If my input mask filled from the right it would...

I would like to have a search box in which someone can type anything and it will search through a few tables to see if this word appears, and then return information from that record so I know who it belongs to. I have a query written that has all of the fields from all of the tables that I...

I have a logo that is part of a very short avi movie clip. Iwould like to display the clip in a loop on open of the form. I found this code in the microsoft help, but it doesn't seem to work: Private Sub cmd1_Click() Dim AviFile As String 'Type the full path to the .avi file on the...

Like the title says I need to have a form that displays up to 20 pictures of people. I have a subject table that includes a yes/no field I have named Add. I use this in a query to say Select * FROM Subject WHERE [Add] = True. This query allows me to select the people I want for the picture...

I would like to create some custom icons and use them in Access. Does anybody have an experience doing this that can start me down the right path? Thanks:)

I have written this query to get the last 20 records of a commodity: SELECT TOP 20 CurrentMonthData.[Symbol], CurrentMonthData.[DeliveryMonth], CurrentMonthData.[DDate], CurrentMonthData.[Close] FROM CurrentMonthData WHERE (((CurrentMonthData.[Symbol])="AD") AND...

I am trying to write a query that looks at groups of records for averages and maximums but the records are only from Mon-Fri (Trading Days). I have a query that runs everyday and compares today's close to see if it is greater than the maximum close of the last 20 trading days. I want to use...

I am trying to replicate a triple moving average function in an access query that I wan to run everyday. This is what I have so far: Table: CurrentMonthData Fields: Symbol, Delivery, DDate, Close Field: DDate Criteria: Date() Close: (AVG(Close) From CurrentMonthData...

I have a table that has the following fields: Symbol, DeliveryMonth, DDate, Close. This table has information for a large number of different commodities. I am hoping to run a query against the table and find breakouts. I am working on the actual query but my question is this: If I have only...