Search results

I might have been a bit confusing in my earlier post so I'll go into more detail. 1st Form cboLineSize (combo box that pulls from a table with line sizes, when it pulls information it gets ID / Line Size) tbl1 LineSize (Field) - Receives information from 1st Form properties: Number - 2...

My problem is occuring due to the following: I have a form that the user inputs information into and clicks a button to save this data to a table. Then the user goes into another form that on load pulls some of the table information. The initial form value entered is based on a combo box...

Thanks for the info, but yah I've done some researching on the forums and come across your points for increasing security. 1. Split database with tables in one and forms/reports in the other. 2. Made the front end user database into an accdb to password the VBA. 3. I know that in Access '07...

Access 2007 I've searched several threads and I haven't come across one that deals exactly with what I'm seeking. I developed a database for multiple users to access. I've set up user login tables that keeps user/pass/accessLevel information. So based on who signs in depends on the user...

it seems like most people in this forum that respond to help have one way of doing things and choose not to show examples why another option doesn't work or why the one they support is better. they just automatically assume that their way is the "only way." personally i think making a user...

if you are referring to using a filter on a form, that won't work in my case. i use forms to write to tables. since a form can be made more user friendly and have more functionality. user enters info into a form - writes info to table - report pulls info from table is basically how my...

If you filter your table and you're pulling fields into your report based on information in the table how would you apply the filter in the report? Table has all data, but you filter it for example just use cars: Initially has all cars so when you open report it pulls in all info You only want...

the smilies are actually semi colons not smilies

Row Source in Table (combo box) IFF([Type] = 13, (SELECT ProductTypes.ProductID, ProductTypes.[Extended Price] FROM ProductTypes ORDER BY [Extended Price];), (SELECT ProductTypes.ProductID, ProductTypes.Price FROM ProductTypes ORDER BY Price;)) I can get a number to pull up but it's the...

So in short: I should just put all the info into one table and pull info into separate reports using VBA code? I'm familiar with forms/tables and somewhat with reports. Just prefer to add fields to a report and have it auto fill. Guessing I'd have to have some kind of VBA code to pull off...

All tables have same fields. Reason there are different tables to place on is due to following: Overall Report: Pulls data from OverallTable IndividualReport1: Pulls data from IndividualTable1 and so forth All tables share same fields, and yes I know that when you write/save to a table...

I'm using forms to write information into tables. The question I have is what VBA code would you have to use to prompt the user on which table he wants to place the item in. For example you are running a grocery store and you want to save a certain item under the produce department, but you...

I have two databases created in Access 07. I'm curious if I can pull info from one database's table and put it into another table after an update and if there is a quick way to do it. For instance an auto update button would work nicely. Example below: 1st Database - Detailed individual...

Was curious how you would code something in the VBA that converts certain text in a field to a number. Example below: Make Ford -1 Toyota -2 Chevy - 3 Model Mustang - 1 Camry - 2 Camaro - 3 So I'd hit a button/key that goes into the fields titled make/model and it converts the name into...

I'm trying to load data that I have stored in a file and bring it into a form. The data was imported from excel and then I'm going to edit it within a from. I'm trying to use the FindFirst function to track an item down by it's Product Number. I have a load button that does OnClick event...

I have a form that does the following: Quantity Cost Each Total 4 2.00 8.00 3 3.00 9.00 Overall Total: 17.00...

Is there a way to define a function in VBA that sums a table's field and automatically puts it in a text box? Currently I'm using the following: List Box with it's RowSource the following: SELECT Sum([Total Cost]) AS Total FROM OverallWeight; The error I get with this is that it's not...

I've created a form by clicking (Form Design) and have put some labels, text boxes, and buttons on the form. The form is designed to help the user find out certain things. I was curious if there is something on the text box such as a property you can change that allows the user to close the...

I'm currently trying to modify my Access 07 database by using Visual Studio 2008 Express. My Access 07 database has all the tables/queries/forms/reports working and is fine, but I'm trying to use Visual Studio 2008 Express to pull in info from this database (just the tables/queries) as well as...