Search results

I want to be able to do something to several labels, e.g. make them invisible, using a FOR loop. They are all named similarly, with ascending numbers on the end, e.g. lblName20 Say I want to make lblName20 to lblName40 invisible. I need something along the lines of: Dim labelname...

I'm making a database of (electronics) chips in Access 2010. These have varying amounts of pins - 6, 8, 14, 16, 18, 20, 24, 28, 32 or 40. On a datasheet, they are drawn as per the following image: http://www.beavisaudio.com/library/555/555_556_Pinout.jpg As you can see, the pin numbers run...

I have a Mail Merge letter in Word that gets its information from an Access database. If I open the Word document manually, I get a message box which says: When I select yes, the document opens up on the last record, and I can browse through the records using the navigation controls on the...

I have a form, frmMailShot, which has an option group, grpMailShotType and two command buttons - cmdLaunchWord and cmdLaunchReport. The option group is used to select whether the mail shot will be the initial mail shot (value = 1) or a follow-up (value = 2). The command buttons select whether...

I am using the Common Dialog API (http://support.microsoft.com/kb/888695) in Access 2003 to select a file. The following part of the code dictates the initial directory opened: Dim OpenFile As OPENFILENAME OpenFile.lpstrInitialDir = "C:\" Obviously, that opens in C:\, which I don't want. I...

I am trying to make a combo box that is controlled by the value in a previous combo box. The first combo box lists genres for games (e.g. RPG, Sports, Action) and the second, when necessary, will expand on this. For example, if Sports is selected in the first, the second would display a list...

I have a form (Games) based on a table of the same name. There are two combo boxes in the table (both lookup from other tables). These are called GameFormat and GameMediaType. I only want GameMediaType to be visible when one value is chosen in GameFormat. I used the following as an...

I've had a look through the many topics on text importing, but can't find anything specific to my problem. One of our suppliers has started offering their catalogue as a CSV file via e-mail. For now, I am saving the file to my computer, and wanting to import it into a database. the table is a...

I would like to create a lookup field based on a table. However, I want the data displayed in a particular way. That is, I want 'dummy' fields for headings, and the selectable items are tabbed from these headings. It is probably best to demonstrate what I mean, so here goes! Sony -PSX -PS2...

I am having a problem when trying to use the Form Wizard. I select a table or query, but it shows no fields! Here is a screenshot: I am running Office 2003 with the latest updates on XP Professional SP2, again with the latest updates. The install was fresh only about a week ago, and I had...

I have recently built a database, part of which was for printing out address labels. The databse worked fine with a few sample entries. I set up the label printing using the Label Wizard. All was fine - it took the relevant data from the correct table (Table called Main, and it gets the data...

I have a switchboard form that opens with the database. One of the buttons on it opens up a standard form for entering names and addresses. I created the button with the button wizard, so the standard code: Dim stDocName As String Dim stLinkCriteria As String stDocName = "Enter...

I have been tweaking my friend's database for him. I included some sample data in the main table (ficticious names and addresses etc.) and in a linked table. I want to leave the sample data in so my friend understands how the database works. However, once he has tested it, he will want to...

OK, this one is doing my head in! I'm using aleb's most handy code from this thread to have a multi select list box that determines recipients of an e-mail from the list. I thought it would be handy to have it make a list that updates at the same time, showing what e-mail addresses will be...

I am using a Multi Select List Box to display a list of names from a table, in order to select e-mail recipients. The names are in two fields: [Main]![First Name] and [Main]![Surname]. I have done this by using the following code for the rowsource: SELECT DISTINCTROW Main![e-mail]...

Hi guys, Thanks for all the help in the past... I'm getting on well with my project for a n00b :) OK, I have a report, based on a query. The one value in the query that I'm interested in is called Price. I have a text box called Total that I wanted to display a value, so I used the criteria...

I have a form that is used to specify criteria in a query, namely the date range for a report (much like the Sales By Year Dialog form in NorthWind). There are two text boxes: StartDate and EndDate. Currently, I have to enter both details manually. I want the report to always list one week...

I want to create a label report based on a query. The database has two tables: Categories and Labels. Categories is used to list (surprise surprise) categories, and is used as a lookup in Labels. I accidentally created a normal report, and everything came out fine! The categories came out...

I want to use a report to make an alphabetical two-column list of items in a table that do not have a Yes/No box ticked. I used a query, which sorts these items alphabetically. The report also works well. However, it will list like this: Apples Biscuits Cheese Doughnuts...

I am having a problem with my label report for my database. I have a table called Labels. This contains the following fields: LabelID (primary key) CategoryID (lookup from table: Categories) Length (text) Price (currency) The lookup is for the field: Category in the Categories table. I have...