Search results

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...

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?

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...

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...