Search results

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...

Microsoft are now charging for the download of the Beta! OK, so it is only $1.50, but that is converted to your local currency, then tax/VAT is added (most likely Microsoft will use their usual trick of using their Irish base and charging us 19% VAT in the UK!)... so it soon mounts up. And how...

Yes, I'm sure you're right on both points! I feared there wouldn't be a way to do this. Also, I think that site uses some form of Java for its menus (or Javascript). Perhaps it would be a point to raise with the Office Beta team? Not that they would necessarily be able to implement it...

Thanks for the quick reply! Yes, I thought it might not be as easy as it seemed! Your solutions are good ones - I think it is probably acceptable to have the manufacturer displayed every time, so that will do! Of course, if anyone has another suggestion, I'd love to hear it! :)

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...

sorry for the bump, but it's been a week now and I still haven't been able to fix this problem! Anyone have any ideas? Any suggestion would be greatly appreciated!!

Thanks for the quick reply! I can get into the design view, but again, I can't add list boxes - it tells me the table contains no valid fields. It isn't just the database though, as it will even do it with a fresh, blank database! As for text boxes, if I changel the control source using the...

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...

Ahh yes, if I put that in the Form Load of the Form with the records, it works great! Thanks, wazz! :)

Yeah, Data Entry is off on both the Switchboard form and the one I want to open. The form opens fine manually, it is just when I use the button on the switchboard, which uses DoCmd.OpenForm with acFormAdd. It also works fine when I use acFormEdit, which led me to believe that acFormAdd wasn't...

Thanks for your reply. I totally agree, the search is great! I have learnt a lot from looking at samples - best way, I think! However, I couldn't find much relevant in this case (might have been poor search words on my behalf), and what I did find didn't work! I should have mentioned, I...

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...

Hey, I have done exactly this. I didn't want to send a report at all. Take a look at the DoCmd.SendObject function. You are using objecttype:=acSendReport I use objecttype:=acSendNoObject, which attaches nothing. The object types are: acSendDataAccessPage acSendForm acSendModule...

That works great - thanks! Only thing is, the primary key has kept going - for example, I had a table with 6 entries, and the primary key when I blank it starts at 7. How can I make this reset at the same time? Thanks for the help! Much appreciated :)

Thanks for the reply! Unfortunately, when I click the button, I get: Compile error: Argument not optional And it highlights .RunSQL Have I missed something obvious out here? If it helps, I'm using Access 2003

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...

That's lovely guys - worked a treat! Many thanks :)

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]...