Search results

I have little to no programming ability so any advice (and details) is appreciated. I have a field called PHLevel. And I want to click a button and based on the results in the PHLevel field open 1 of 3 forms (with just words on it). So basically I want something like this If PHLevel is < 7.2...

I'm currently using the access sample inventory control database http://office.microsoft.com/en-gb/te...001018458.aspx but I need some assistance in modifying it. I'm working on a database where I can track my swimming pool chemicals on hand quantity and costs. Like I said I have the sample...

Can any one tell me why this wouldn't/doesn't work? Private Sub fee_label_Change() If Me.fee_label = "Adult Registration: No t-shirt (Early)" Then Me.fee = 10 ElseIf Me.fee_label = "Adult Registration with t-shirt (Early)" Then Me.fee = 20...

Is there a way for in the else part of the code to have 2 things happen? I have this: If Me.Family = "1" Then Me.FamPoints = "3" ElseIf Me.Family = "2" Then Me.FamPoints = "2" ElseIf Me.Family = "3" Then Me.FamPoints = "1" ElseIf Me.Family = "4" Then...

I have a simple database that we use that we put our payables in and then I export the report to a txt file. In the db I have a lookup field that has all our accounts and information in, I did this to eliminate fat fingering and errors. Anyway when I view the export txt file it is showing the...

I am trying to use the DoCmd.TransferText acExportFixed command to create a text file. but everytime I run the code I get the error Run-time error '2511': The action or method requires a Specification Name argument. I have created the Spec file by doing the export clicking on the advanced tab...

Hello All, I am using Access 2010 and I'm trying to automate a report that we run every morning. What I want to do is click a button and have it open my query (query1) in design mode then go the Date field and change the Criteria to todays date. Is this possible? The other part of this is to...

in my database I have a query running and I'm exporting the fields of this query to a csv file. The export is working good but what I want to do is in my query I have a comments box that when I export I just want to export the first 70 characters of that file. This file is eventually being...

My ultimate goal on this project is to take information from my database and export the information into a csv text file. Right now I'm working on phase 1 of my goal. I'm trying to run a query based on 3 fields of my form. On my form I have a Start Date text box (txtSDate) an End Date Text Box...

In my database I'm comparing data in 2 tables and returning the difference. For example Table1 will have Joe Blow $75 Table2 will have Joe Blow $50 then my query will return Joe Blow $75 $50 ($25). So in year 1 Joe spent $75 with us. In year 2 he spent $50 with us. so the...

How would I go about doing this: If ContainerType = Box then Container must equal a number between 1 and 200. If not in the range then message box. My thoughts are to put it in the Before Update section sound right? Along that lines how about this one: If a container number is already used then...

I have a form with a subform on it. My subform gets populated by a lookup. On my main form I have an unbound (cboLotIDLU) lookup field and also a text box (LotID) that shows the chosen record. When I open the form my cboLotIDLU is blank but my LotID has an ID in it so the info for that ID is...

In my DB I'm tracking seed. I have a form that I enter in some info in and an ID number is created (based on that info). Then in a different form I track "events" that happen to that ID (drying, moved, bagged). Is it possible to have a button or something like that that after my ID is created...

In my db I an tracking different types of seed and the process from harvesting the seed, through all the stages of drying and so on all the way to being bagged and sold. I'm not tracking the sale other than it was sold. On my Events Form I have a subform on it. On the form portion I have a combo...

On my form I have 2 radio buttons rdoAll and rdoSpecific. If rdoAll is true then it prints a report. THis part works fine. However if rdoSpecific is true then I make visable combo box to look up an ID. Then when I click the button I want the same form to open but with just the info pertaining to...

In my db I am tracking different stages for an event. I have a subform that is in datasheet view. The last field (current) is a yes/no check box that says that this entry is the current stage of the process. In one of the fields I have a afterupdate event that says me.current = true. But what I...

Can someone help me out by looking at my database I've been messing with it for 3 days and I can't figure it out. I have 4 tables each are in a 1 to 1 relationship. From there I have a query that is for every field between the 4 tables. I then have a Tab Control form with 4 tabs and it uses the...

Tab Control with Subforms / "Can't build a link between unbound forms" error I am trying to create a database for a cub scout pack that just keeps scouts information, medical info, parents info, and parents medical info each is a seperate table. I have created a Tab controlled form with 4 tabs...

My database is written in Access 97 (I know get out of the stone age) but we have a mix of office 97 and office 2003 users. Anyway I'm afraid that one of the few people that have access 2000 or higher will open my database and convert it. I found (through here) code to check the version but it...

I have a library database that I want to delete a record in my tblStatus when the book is returned. I have found the deleteobject function but it appears that that will delete like a table or query or report or something like that. I have no need to keep track of how many times a certain book...