Search results

Hey Guys, I'm trying to implement the MouseWheelHook method in order to disable mouse scrolling on one of my forms, but I can't seem to get it to work. Here's the link to MouseWheelHook: http://www.lebans.com/mousewheelonoff.htm#Tips%20from%20Users%20of%20MouseWheelHook This is what I've done...

Hey Guys, I'm working on an invoice database and have run into a little snag due to my lack of VB knowledge. I was wondering if you guys might be able to help out. I've got a invoice entry form which has two text boxes [name] and [invoice number]. The user enters the name first, then the...

Hey guys, I currently have an Access database designed to handle daily invoices for a company. This database has been in existence for a few years now, and I really want to revamp the look and feel of things (i.e. the forms). I was wondering if you guys would post some pics of your...

Hey guys, I've got a form that allows users to enter invoices into. On this form there is a field where the user enters the date of the invoice, and it is in turn stored into in a main table. This field is called [Invoice Date]. I want the current date to be automatically entered into this...

Hey Everybody, I have 2 tables, one called [Addresses] and the other called [2006_Contacts]. The table [Addresses] has a number of various fields relating to contact data of people. The [2006_Contact] table has 2 fields [Last Name] and [First Name]. I want to run a query that pulls the...

Hola Amigos! The other day, I just began learning Visual Basic so I could convert one of my Database front-ends into a stand-alone program, but I have run into a small problem. When my front end was an Access Form, I had a combo box that had 2 columns. The first column was stored into a...

Hi everyone, I have been developing Access Databases for about 2 years now. Up until now, I have always used Access forms as my front end. I really want to learn how break out of Access as far as a front end goes, and learn how to write my front ends in VB.NET. I have searched google for...

Hi guys, I have a form with an option group. It has 2 options. The first one has a value of 1, the second has a value of 2. This option group is named "category". Separate from this I have a query with several fields. In one of these fields, I need to enter a criteria that enters "LOE*"...

Hey everyone, I thought I would take a break from Access and ask you guys what you think of Falcon Northwest's Fragbook TL-2. I am currently looking for a college laptop, and I came across this the other day while surfing the web. I would love to hear your guys' thoughts and opinions! You...

Hi everyone, This is a very simple problem, and it seems to me like it should work but it doesn't. On my form, I have a field called [mindate], which looks up the earliest date from a table. I also have a field called [maxdate] which looks up the latest date in my table. These both work...

Hi everyone, OK this is a pretty big question, but here it is.... I am not quite sure that a query is the best thing to use in this case, but I think it might be possible. Here is what I need to do: I have a table with information about oil well production. In this table the production of...

Hi everyone, I have been developing an invoice database system for my company. Right now they enter all the info from their invoice into an Access Database via a form. I got an idea, and am curious to if it is even possible to implement. I was thinking it would be really cool, and useful, if...

Hi everyone, I have a table which includes several columns. Two of these columns are important for this update query I wish to do. In my table, I have two columns like this: API# Current Operator --------------------------------- 1 | 1 | 2...

Hi everyone, I have a form with a date field on it. I would like the date field to automatically enter today's date, which it does now, but also I would like it to retrieve the previous record's date and if it is different from today's date, I want the form to use the previous date as the...

Hi everyone, I have read through all of the previous posts that I can find, and I understand that it is impossible to convert an access form to an .exe file. Currently I have my database broken down into a front and back end. Is it possible to independently write a visual basic application...

Hey everyone, I have a crazy idea that I think would be very cool if I got it working, but have no idea where to start. I have a database that is broken down into a front end and a back end, and there are about 10 users who use it off and on throughout the day. This database has an entry form...

Hi Everyone, I have a situation, and I am wondering if there is a way to use an update query to make my life a little bit easier. I have a table with around 9,000 records, and 7 columns (for reference this will be table A). Column number 1 in table A is a lookup field that looks to table B...

Hi, I am just wondering if anyone would be able to help me write a section of VB code, since I really don't know VB very good. Here is what I am going for: If (([stock]-[stockbefore]+[sales]) == [oil]) { Print in Text box "OK" } Else { Print in Text box "Error" } These fields are on a...

I'm somewhat new to VB so please hang with me. I am trying to run a query using VB when I click a command button, then close the query so the user doesn't see it happening but it doesn't seem to be working. This is what I have for code so far: (My Query is named "DateWellPrevious") Private...

I have a form based on a table called "WellData". I want to have a text box on this form that shows the first value in a field that is in a different table called "DateWellPrevious". The field is called "Oil". I tried this as my textbox control source, but it didn't work...