Recent content by tkaplan

this is exactly what i am asking for help with. How do i code to check if the excel file is linked?

From my experience, many companies dont use access because they dont have someone who knows it. when i came in to where i currently am, they were doing everything in excel. they dont realize that excel is a number cruncher, access is a database, they think it is exchangeable. I have developed...

to open the find file dialog box, i know how to do. here's what i dont know how to do: when user opens access database, access is looking for the excel file. if access does not find it, set off code which will do whatever. (the whatever part i know how to do, i dont know how to write for the...

i want it to pop up automatically. I know how to open it in design mode but my users dont, and i dont want to teach them. i am trying to figure out a way to make it come up on it's own and prompt the user.

i dont believe you can do it in the actual table. i tried something like <=[Paid] but it returns an error that you cannot use multiple columns in a check. is there a specific reason you want it in the table design? are you not going to be using forms??

on the form that the user will be entering the data in set the enabled or locked or visible property (or any combination) as false. then in the onselect event of paid, put if paid = true then confirmed.enabled=true else confirmed.enabled=false end if

I have a database that is really just a bunch of reports based off of one excel sheet. I am using the excel sheet as a linked table. My problem is that there is going to be a number of copies of this database in use, and i want the user to be able to say where this excel sheet is located, but...

glad to be of service:) please let me know how it goes...

I have multiple reports. I would like the user to be able to see a main one, which has averages of six different sections on a test. I would like that the user can click on a button (or some other event) under one of the sections that will open up a detailed report of that section. I would also...

see the following link for dynamic crosstab reports. I believe you can use the same method for changing your textboxes and labels. http://support.microsoft.com/default...;en-us;Q328320

I need some help with charts: I know that the wizard wont allow me to put in more than six fields in the chart. Is there any way that I can get around this??? PivotChart: if i have a field named "Jan", when i put it in the pivot chart or table as a sum, it changes the name to Sum_Of_Jan. Is...

I have a form with a listbox on it. the list box contains site numbers. (lstSite) i would like the user to select which site/s they want information for. i have another query that includes site,date,and other data i put in the criteria for site as being forms!main!lstSite.value but it is not...

i need the user to be able to select more than one value, so combobox would not work. thank you anyway. I think i need to use some sort of code to have the values of the selected put into an array and then split that?? anyone have any suggestions?

I have a form with a listbox on it. the list box contains site numbers. (lstSite) i would like the user to select which site/s they want information for. i have another query that includes site,date,and other data i put in the criteria for site as being forms!main!lstSite.value but it is not...

does anyone know a good link that will help me with creating dynamic crosstab reports? i have never done this before and have no idea how to do this. Thanks in advance.