Search results for query: *

Need to transfer my form to another computer, don't want to revert to old data though.

Okay here's the dilemma. I'm not really making the database for a customer but rather my boss. He's more of an Approach user and likes the slimline, "not a lot of background and toolbars", kind of user. I made him a form that creates document records and generates reports based off...

I have a note field, a memo field, and a memo2 field that I need to merge together into one column. They're essentially the same thing (just notes). Is there a way to do this in access and/or excel?

I have to create a new table with a certain type of structure. Usually I do this by copy and pasting and then selecting "structure only". I want to now streamline the process and make a wizard-like form to do everything for me (prompt directions, copy paste tables, take input to name...

Okay I'm a C++/Java guy so I might have the wrong idea on how subroutines work. Anyway I have a combo box drop down menu that is assigned to a string variable 'tblName'. I want to "pass" this string into a function for storage so when the form containing the combo box closes, it will...

Okay, in an effort to make a form refresh instantaneously as soon as search criteria from an SQL statement is sent to the query isn't working so well. I though that putting a refresh button on the subform that houses the query would make it display but it doesn't. I even tried sending the SQL...

I have it coded here: strSQL = "SELECT " & tblName & ".Page, " & tblName & ".Date, " & tblName & ".Subject, " & tblName & ".Company, " & tblName & ".People " & _ "FROM " & tblName The thing is, I want the tblName to be...

Okay I have a search form that executes code to send an SQL statement into a query with a click of a button. However, I want that same button to refresh a subform to display the results. How would I go about doing this. Right now, I have that subform displaying the query so for example, I'll...

Thanks in advanced for viewing this thread cause I know it's a pain to answer noob questions... but it has to be done! Anway here goes: I'm going to start a site containing lots of media from my friends and I (videos, pictures, music) and I wanted to host it on a custom name. I looked up the...

Okay you VBA experts can probably answer this one in a second and a half. 1)I have a private subroutine that basically takes whatever the user selects in a combo drop down menu and attaches "tbl" + cmbmenuselection. So I have a dropdown menu with "Books&quot...

Is there an ActiveX controller that will load and put Adobe Acrobat onto a form? And will it be able to display a specifc page I want? For example: I have a search form that searches for different subjects on pages. When that subject pops up, it gives me a list of pages within a query. Say the...

Okay I have a list with numerous names. Some of these names have duplicates and some do not. I would just go through all of them and filter out the duplicates myself but there are too many entries. How do you query the table so that you get a list with each name once. eg: BOB LENNY CARL LENNY...

Okay this is a more specific question on a search form. I have it working just fine so that it will search a field that usually contains more than one word (for instance it is a memo field, or a note-to-self field, or any field generally longer than name, last name, or DOB etc). However, it will...

Okay this might be a complex question (though easy to answer) depends on how well I explain it hehe: Okay, I have a combination drop down menu that displays different titles of books. Each book will have it's own table that is named "tblBook" 'Book' being the first word of the title...

I have this form to fill out page descriptions of each notebook. I want to have one form for the 30 or so notebooks and so what I want to do is make a drop down menu to change the record source. How would I go about that using VBA?

I just want to know the syntax to clear a field in a form. VBA Idiot

Data is supposed to be small right? Well, even after I changed field sizes to as small as I could get them, my Access file is still 102mb for one 3000 entry table with 11 fields, and two really small tables with about 10 entries each. Then I have 11 reports with an 18kb graphic on each one, 11...

I have search form that can search by date range. You just give it two dates and it pulls up a report about it. However, I'm not that experienced with VBA and I want to know how to display a msgbox when the user doesn't enter the second date (or one but not the other). Anyway, here's the segment...

I got asked to do a search form for an Access database and since I've never done one before, I want to know where to start. Okay, here's the deal: There are a bunch of fields, project name, title, date, group, etc. and I need to make a form to take user input, filter them from the database, and...

Up until now, I was positive I did it right. But my CPU temps are a little high: 46/56c idle/load on a P4 2.4 @ 3.1ghz. I read up on the AS3 sight and followed using the plastic bag on the heat sink and then using a credit card on the slug. That came out a bit rough (edges of the card and little...