Search results

Re:Macro/Menu Thanks Pat: Its so easy, I was looking in the wrong areas Thanks Pat, I'm learning so much from you Dennis

macro thanks for your reply I will give it a try and see what happens. have a nice weekend Dennis

Macro You right Tom is a pop up frm. I will investigate your suggestion asasp thanks Dennis

I created a new macro in Access that import an excel file called Master into a MS Access, it works fine. My question is I would like to get a dialog box to open when I run the macro and be able to type the name of the new excel file to be imported into Ms Access. the current code is...

Macro Code? you mention ." If you want to see what code a macro would generate, you can use the menu option that converts it to VBA. " Where and how do I get there, I'm a novice when it comes to this can you help please. thanks Dennis

Importing excel file into MS Access Well I just finished creating a macro that imports an excel file into Access. First thing you do is import that delimited file into an exell file. then 1. Name the new exel file master (create a permanent file location in your computer example D:/...

I created a new macro in Access that import an excel file called Master into a MS Access, it works fine. My question is I would like to get a dialog box to open when I run the macro and be able to type the name of the new excel file to be imported into Ms Access. the current code is...

Please help. I knew how to do this long ago, today my brain is not working properly. When I open the main form [frm DataDepot]I have a cmd button that opens second form[frm_approval]. I would like to go to the same specific record. I'm linking both frms using Id[auto numbert on the main] and...

Hi, Check your linkmaster links and your child subform links. the reason it works by itself is because is not link to anything, but when you open thru the switchboard it shows the parent as well as the subform. correct!!!! Dennis

Hi, just wondering why you print the form and not a report. if you just want to print what's on the screen, one option will be pressing "ALT"+PRINT SCREEN" and pasting it on a word notepad or an excell file. The second option will be to select file/ print / selected record only, This is located...

Go ahead send me a copy dgavilanes@csc.cps.k12.il.us Dennis Make sure you zipped

designed in access and publish it in word. when you go to reports you can published in word or excell. or go to file/export/ as rich text an it will print in word format. Or are you trying to place fields from access in a word document. If that is the case all you need is a query. go to the word...

your calculations should be done on a query, unless you know how to use code. Example 10+10=20 first field is a number 10 second field is also a number 10 last = [field1]+[field2] 20 look in the northwind sample database from access, plenty of samples there...

First before you execute print add a record and see if it saves to the table, if it does then check your primary key, is it an auto number or a specific number that you as primary. When you get a warning that you are creating a duplicate that means that the system recognizes a record in the...

your relationship is not correct. Is the second form nested within the main? On the main form your MainID (Autonumber with a primary key) and the second form (subform ID ) is a number. If you have problems let me know for second option. send a copy so I could see it, first try it yourself Dennis

did you check the relationship between the main and the nested subform Example Main ID is (primary key) and the nested form is (sub Id= number) one to many . So the main record is "Mikey Mouse" on the many side, cars boats etc. Dennis

First check the query make sure it shows records and the fields on the query matches the one in the form then when you select the query for data source make sure it the correct one. If that does not work, start with one table in the query and see if that works, add the next and see if that work...

Just copy the form and paste it, go to properties and link it to an empty table source. Dennis:

looking for a plain calendar db,Accsess2k to use it as an appointment scheduler thanks Dennis

I have a main form named "master" By a series of butttons the current subform is replaced by selected button with a different subform. Unfortunaly the main frm does not link with any nested subform. Any ideas thank you Dennis