Recent content by melanemac

I have a Microsoft Access Services Database that is stored on it's own Sharepoint Site. One of my tables has a date field that stores the date as 10/01/2008, etc. When I open the table, I can clearly see it in that format. I then have a query that is linking the date field on that table to...

I have a database that needs processes from two other databases to run in order to work. So DB1 runs and then DB2 uses data from DB1 and runs then DB3 uses data from DB2 and runs. Because we use DB1 and DB2 for other processes, it doesn't make sense to put those processes into DB3. Further...

OK, I thought I posted this, but I can't find the post. Again, I'm working on a programmer's db and would like to automate a feature in Excel, instead of having hard coding from Access. I have a db that is spitting out data to Excel, line by line. I would like to make the cells have...

Thanks. I finally found that, along with the option of using double double quotes, which is easier. http://www.dailydoseofexcel.com/archives/2004/04/16/worksheet-formulas-in-vba-part-i/

I tried that and it didn't work...it errored out on me. Besides, I need the double quotes to show up in Excel.

I have a programmer developed database that I need to update on occasion. There is currently a field that is being input from Access VB into the Excel document that is writing a "hard" field". Instead I want a calculation. I want the cell to read the following formula when complete...

I have two tables. The first table EES has the list of employees that I need and their information. The second table EPAY has even more employees and each employee may have duplicate rows. I am wanting to delete any employee on EPAY that does not exist on EES. I tried creating a delete table...

Does anyone know how to change all linked tables in a database to unlinked? I want to save a database for offline testing and want to save the tables as flat tables instead of linked. Is there anyway to do this without bringing them all back in unlinked?

figured out two of the points... 1. I just needed to pull something over...it was pushing another page. 2. When you are in the subreport, instead of creating the column headers in the report header section, you can create a group and place them in the group header. Then you change the...

That part was easy... Once in your main report, go the toolbox and choose the subform/subreport button (4th from the end). You will have to create a box in your detail section. That will then guide you through the subreport wizard. As long as you have a field that will link to your field in...

Unfortunately, I have no idea how to write code in Access. I've only ever built reports visually. Also, I want the beginning of my last subreport to print on that page, because the majority of my positions will only be one page.

OK...I need a bit of help here. I have put everything together for my report, including 4 subreports, but am having a few problems. I have been scowering the forums here and just can't seem to get these figured out...hoping you can help. PDF of Report results attached. Report overview: This is...

Thanks Thanks. That worked for the null field, but I would like to try and take the "Make Table" out of the equation. Is it possible to do a count on the fields if one of the fields is #ERROR? I have tried the ISNUMERIC and ISERROR and I can't seem to get them to work. My queries start as...

I need to create some calculations. I have some fields that are calculating a number (see below) * a percentage. Some records may not have the number, so they are coming out as #Error in that calculation, which is fine to me (this is a multi-step query). Field1 Field2 Field3...