Search results

This has been driving me crazy! I'm trying to add data to an existing table. First I tried my usual, importing data from Excel and adding to the existing table. The field names are identical. But I got an error that they couldn't be added due to violation of the validation rules. So I imported...

Does this happen to anyone else here? I've pulled some data into Excel from other software. The column headers are made the same as in my existing Access table. I set my print area, save the Excel workbook, close, and then try to import in Access. And the import dialogue won't recognize my...

This was exactly right. Thanks! I had a similar issue with having deleted the switchboard I'd made, but having it continue to pop up an error message, but by searching this board I found the answer to that too!!:D

When I enter Access either by opening a database file or by opening the program by its desktop icon, I continue to get an error message saying: Microsoft Access can't change the working directory to Y:\database. Verify that the drive is valid and the path is 260 characters or less in length."...

Thank you again. I've been pulled away on other projects and recently down with the flu so I'm just getting back to your message. I appreciate it! -- A

That's a very good question (about transferring the menu items) and one I don't know about. I thought those properties were resident in the program files, rather than workbook files, and I don't know how to efficiently transfer them to other users. Hopefully someone else can chime in on that. --Ann

I built the darn switchboard to simplify for a coworker's use! And though it appears fine on my PC, on hers it not only won't auto-open, it won't open at all. The piece of code highlighted as the problem is triple-bracketed below {{{ }}}: ' Open the table of Switchboard Items, and find '...

at present its a macro which runs on the <<onclick event the macro at present states to: opentable--->properties openform--->add new property gotorecord ---> new close --> form--->main any suggestions, ive tried it opening next file all to no avail argh!!!>> Have you tried adding another...

Perfect! Thank you. I'll bet there's a good book for this stuff, but the one I'm using is "Sams Learn MS Access in 21 Days", which doesn't go into a lot of this. Thanks! I've already converted my macro to a module. What I couldn't figure out THEN was how to add my module to the Switchboard I...

Depending on your setup...if you are creating all your macros in your Personal Macro Workbook, and providing your colleagues don't have macros of their own, couldn't you just send them your Personal Macro Workbook periodically and instruct them to save it? The location would be "c:\program...

I have a message box popping up before my macro runs. I would like to modify that to give the user a choice to cancel. In other words, two option buttons, one saying "OK" and the other "CANCEL". I'm enough of a beginner to be clueless as to how to do this. Can I do it in a Macro or will I have...

If all you have to do is bring new data into an existing table, that's pretty easy to write as a macro. Press NEW to create a new Macro. In the first row in the Action column, use the pulldown menu to select TransferText. Then look at the boxes at the bottom left. The first one should be...

Well! The LIGHT BULB just went off for me. For one, I realized I was performing my two queries a bit out of sequence, and that my *first* query should be to compare two tables using the technique you showed me. My second query brings in the rest of the information I needed and that way...

Alex, I can't thank you enough for your help so far. I don't know whether I'm just too inexperienced (I am, really) or am trying to do too much in one query, but I can't seem to get the query to work. I end up with seven matches to every ad instead of one. If it's not abusing this forum too...

Alex, that was perfect. Just the memory jog I needed. Thanks! My new problem is figuring out how to work around one program that runs from 23:30 to 00:30, thereby spanning two different days. In broadcasting (U.S.), this time is often referred to as 24:30 because the broadcasting day is...

I hope I can explain this properly. I'm trying to come up with a way to take a list of items with exact times and match them up with another list of items containing a start and stop time. Specifically, a TV ad is broadcast 1/1/2002 at 17:57, and I want Access to assign the record from another...