Search results

I have a listbox. I have the AfterUpdate property working fine. I can keydown the keyboard arrow key and my AfterUpdate sub runs. If I use the buttons on the listbox control to navigate the records the AfterUpdate does not trigger. I've scoured the web and found nothing. I need to capture...

This code works fine in Excel, but when I put it behind an Access DB it gives me a 'Run-time error '13': Type mismatch' error. Dim ctrl as control Dim ctrlName as string ctrlName = "whatever" Set ctrl = Me.Controls.Add("Forms.Label.1", ctrlName, True) I know it doesn't like the...

I use Excel a lot, and in Excel I have created small code libraries that contain functions that I use over and over and over and over.... The one I am concerned with has functions that are responsible for executing commands within a seperate application. I have saved this as an xla file or an...

My SUMs are getting screwed up... If I do this I get the correct value: SELECT HOLDERS.CUSIP, Sum(HOLDERS.ORIGINAL_FACE) AS [ORIGINAL FACE] FROM HOLDERS INNER JOIN TEMP_HOLD ON TEMP_HOLD.CUSIP = HOLDERS.CUSIP WHERE HOLDERS.CUSIP IS NOT NULL GROUP BY HOLDERS.CUSIP ORDER BY HOLDERS.CUSIP But...

I have a section of code that I have running as soon as the db is opened. It is supposed to refresh the tables so that they are populated with the most current data. I keep having an issue with my JOIN queries not running correctly or if they do run correctly, not inserting the values pulled...

This is a stupid question I'm sure, but it may prove helpful to me. I have an unlinked subform on a form. This unlinked subform contains the contents of table: employee. What I want to do is have a textbox that, when typed in, will auto filter out records that don't match what was typed so that...

I would like to reference multiple sources in my insert and I wonder if this is possible. I have probably set these tables up incorrectly since this doesn't work. Basically I have a Customer table that links to an address table by the AutoNumber CUS_NUM field which is primary key in both. I...

I'm sure that this question has been asked before, but my google searches and forum searches weren't coming up with what I was looking for. I would like to add values to tables from values entered into text boxes on a Form using only sql, if possible. Can I reference a textbox name in SQL...

I'm creating user form items (text boxes/combo boxes) for a user to enter data in. In this case it would be for a part. What I would like to happen is, if there is more than 1 part, then after the first part is entered, another part entry item is added below the first one but only if the first...

I'm creating user form items (text boxes/combo boxes) for a user to enter data in. In this case it would be for a part. What I would like to happen is, if there is more than 1 part, then after the first part is entered, another part entry item(s) are added below the first one. For a virtually...

I am trying to make forms for my database class. What I have so far I am pleased with and would fulfill the project requirements just fine, however, I would like to add a little touch to really make the whole thing professional looking. There are two check boxes that are visible when you...

I have this little ditty that I would reallly like to work. I'm actually copying this from an existing database and trying to get it to work for mine. So far I have had absolutely no luck. The other db used a query, I am using VB. I don't know what I am doing wrong. All the objects are valid. Do...

I'm trying to turn an access query into VBA code and was wondering if I could get some pointers on what I'm doing wrong like things I should change and things I shouldn't. The query: SELECT Suspense.CUSIP, Suspense.Account, Suspense.[Registration Code], Suspense.[Payable Date]...

Alright so I'm at the next stage in my noob database/thing. I want to import a text file and I came across this after a couple searches: Set cncurrent = CurrentProject.Connection Set rsDiag = New ADODB.Recordset ' Open the text file Open "F:\Documents and...

Hey guys. I am new to this forum as of 5 min ago. I have recently begun taking some database classes and have become interested in Access. I have a little bit of programming experience in VBA using Excel. This is, obviously, not Excel! What I need to know is how to use a button on a Form to...