Recent content by kubanvz

Hi all, I have one main Access database file, and many users link into its tables. Can I, through VBA, identify the files that are linked in? Really, I'd like the user name (or computer name) and the file name. Or, can I via VBA break the links, so I can modify the main DB when necessary...

After trying various code in various events, I ended up going to this user's computer, opening the report, going into setup, changing it to potrait, then back to landscape, then I saved it. Now it seems to be funtioning correctly. Maybe some code, that on open changes the orientation to...

I did not specify a certain printer, so the default is being used. I did change the user's default printer, but the problem still occurred.

I have created an Access database, that contains a fairly simple form, with a button, that launches a pretty simple report. The report looks fine on my PC, and a couple of others. The main user's PC however, the report is messed up. Specifically, it appears to revert to portrait, when it...

Hello. I have a problem with charts w/in a PowerePoint slide. After I have created the chart and go back to slide view, the text within that chart, the numbers on the x and y axes, the title, legend, value labels, all of it, appears to be bolded and squished together. Totally unreadable...

I am a report analyst and have been tasked with creating ACD-related reports from data supposedly in Procomm. Basic stuff I think, like how many calls, what kind of calls were taken when, etc. How/Where do I start? I need the data to be in a table, or at least a text file or flat file, so...

You could create a new table that contains one record that contains the desired date. Then modify your queries' date criteria to be equal to the date field on your new date table, instead of using paramenters. That way, you should only have to input the date once. You would not be prompted...

I am not sure why you are experiencing this problem, but you might try the following: You should make a copy of the database "as is" first, and try these changes on a TEST or DEVELOPMENT copy of the DB, in case something blows up, of course. Create a date table (DateTbl) with 2 fields...

Try these in query design view, assuming the existing name column is "Name" Last name: Left([Name],(InStr([Name],",")-1)) First Name: Right([Name],(Len([Name])-InStr([Name],",")-1))

Nvermind. I figured it out. I am posting the solution just in case someone else has the same question. I went into the row source property of the chart and used the Format function on my number field, with the format of "##,##0", and it worked.

I have a simple stacked column chart on an Access report, with a data table. The numbers on the data table are in millions, and COMMAS would make it a lot more readable. I have tried everything I can think of. I can format the X and Y axes and legends and titles, etc., but not the numbers in...