Search results

I have searched every nook and cranny and found no solutions for this problem… My database hides the access window so it resembles a standalone application. I’m not sure if someone screwed with something, but today I noticed an error while opening the database. Error #: 2475 You entered an...

Hello, I’m just asking for some opinions on my recipe data modal. Besides programming, cooking nice meals has always been a big obsession of mine. I’m thinking about creating a recipe database. This is just a rough draft and I’m always open to suggestions. Let me know what you think

I have a wonderful database I designed almost 2 years ago. Other than a few hiccups with corrupted data, my employer is 100% satisfied with it. I’m graduating this winter with an AS in computer programming and I would like to update the database to a VB/ADO .NET (VS 2003) front end before I...

I created a multi-select listbox which I populate with “distinct” furnace names that have been entered into an inspection table. The end user has the option to delete records from the inspection table. The listbox gives the end user the option to filter results on a sub-form, nothing more. When...

Our quality dept had a glitch with the LCD monitor while entering records. From the email I received the LCD screen went black so they abruptly pushed in the PC power button. Now I get a “disk or network error” when I try to open the database. If I attempt to copy the database file to a new...

How do you set a blank field in a report to "N/A" or just 0? I have tried Nz([YourField],0) and iif IsNull([YourField],0,[YourField]).

Pictures are worth a thousand words The image is a subform that is displayed in datasheet view when executed. I have a check box called “exclude” The purpose of this is to exclude specific results from the data when performing calculations. In the footer I have several text boxes which I use...

I’m interested in updating my current Access database to a standalone VB app which connects to the MS Access database. Is this a good idea or should I go with SQL Server and VB.Net? Does anyone have a book recommendation for MS Access with VB.NET?

I have a report which lists a summary of “customer parts”. Don’t ask me why but my boss is bugging the hell out of me to change the format of this report to display the spec high and low, Stdev, and Avg on only ONE horizontal line per part. As you can see if a part number has two or more...

How do i update a table with a value inside a text box? This is what i have . CurrentDb.Execute ("INSERT INTO tblCUSTOMER ( CUS_NAME ) " & _ "SELECT " & Form_PUSHER1_LOGfrm.TextInsertNewCustomer & " AS Expr1;") AND CurrentDb.Execute ("INSERT INTO tblCUSTOMER ( CUS_NAME ) " & _ "SELECT...

I have two text boxes which store medium times (hh:mm Am/Pm). How can I calculate the time difference for these two medium times (Start = 11:00Pm, Stop = 12:15Am = 75 minutes)? I know the time difference will never exceed 24hrs. So I don’t need the dd/mm/yy. Could someone point me in the right...

For my job history entity should I just store my placement number and remove the candidate number? Since placement number already determines the candidate number in the placement table.:confused:

I apologize for asking this question. I have searched all over these forums and on Google. I’m looking for a function that decrements the current date (by day only) based on a single integer value. For instance, today is 8/28/06. A user enters 5. The return is 8/23/06. I’ve looked into...

How do you tab out of one subform and into another from the main form. I have 3 subforms and after a user is finished entering data into the main form the first subform sets focus. After data is entered into the subform it’s impossible to hit the “enter” or “tab” key to move onto the next subform.

I’m working on a new database which will record furnace logs for a heat treat company. I did my best to normalize the tables. I’m trying to add new records through a select query which updates multiple tables. My problem is I don’t believe I did that great of a job normalizing the tables because...

I’m designing a database for a metallurgical lab. Everything works fine except I have nothing in place to check for typos in my inspection results field. With 15,000 records added in the past 2 months it’s very cumbersome fixing errors when a PPK report needs to be printed. My approach is to...

I want to add a filter search on my forum which will look up load numbers based on the selection from 3 other combo boxes. I already have two combo boxes; Customer & Load. When the user selects a customer the Load combo box grabs all load numbers from the database with this customer name. I...

I was wondering if this was possible. I did a search on Google and on this form and I could not find anything. Is it possible to display a form without displaying Microsoft access in the background? In other words I would like to display just the form alone with access running or if possible a...

I have a customer subform on page 2 of my inspection log. A combo box at the top allows the user to lookup customers based on name. My problem is after I enter a new customer and part number into the database it shows up in my combo box but I cannot get my two underlying subforms to pull up any...

I am converting a log book over to MS Access. The log book contains information on inspection results for a metallurgical lab. I have one problem w/ my “inspection table” which I will explain later in the post. This is the plan I am using to figure out my entities and attributes for the...