Search results

I am working on a form in excel with several macros. Currently, I have it set up so the user clicks a "save" button and the sheet they are working on saves to a specified file path under a new name as a new xls. The problem is that the macro buttons that I designed also transfer to the new wb...

That would work but I have 1300 DETLOCs spread over 24 regions so the relationship is a many to one (org code). The vendor_no uniquely identifies things. Right now, I am capturing 90% of the expenses. That is fine in terms of projection. But still want to capture all the charges that are Org...

I will give you an example that hopefully can explain things a little better. Lets start with Atlanta. As I mentioned, there are 24 'regions' that the country is broken up into. Each has their own 20 digit Organization Code. After reading the first 8, you kow the region. The rest are there to...

Is there a workaround solution for that? The reason is because I have some vendors at multiple locations. If I just match vendor_no with a DETLOC I will get all of those DETLOCs for each financial transaction record with that vendor_no.

I have two tables I am trying to join. Table one contains financial data and table 2 contains vendor infomation that relates to the data via a vendor_no. Because of the data quality issues I have to deal with I cannot match up a vendor_no to a location (DETLOC) 100% of the time. In in a case...

yes that is exactly what i want to do. my question is how do i do that.

two separate sheets was my first thought. however, i need multiple sheets for each company that i am profiling. so when it comes to insurance each tab will represent and insurance company. then within the tabs there will be two 'sections' on the sheet. Also, access would be better suited to this...

hi guys, this one should be a softball for some of you but it has me stumped. the scenario is this: I have a worksheet that i open and can select two options from a user from. you can select either 'home' or 'auto' (we are talking about insurance). you can then enter about 6 columns worth of...

Also, because there is a "notes" section, sometimes the rows are more than 1 row apart. thus, it would be difficult to just use a 'row+1' code to move to the next cell and input data.

The data from access all goes into the same column but in non-contiguous rows. There are spaces between the rows to make the report easier to read. So for when I describe expenses for Program 'X', the values go into A1, A3, A5, A7 etc.

I am currently running a VBA script that imports my Access 2007 table into Excel. I have set it up to import to a sheet in my workbook called 'Data'. In the main sheet, where the calculations are done, I use a sumproduct formula to find and calculate values from the 'Data' tab. In this way I can...

FIXED. The problem appears to be a flaw in access that won't allow special characters in the file name for the back_end of the database. I had an apostrophe that was causing the error. It seemed strange that most queries still worked but i guess there will be a service pack sometime in the...

also, i just noticed that i get the same error message when i try to open my relationships window. my relationship is also deleted and when i create it again and save it doesnt work. this is very strange

I am able to recreate in after the split and correct one of the queries i was having a problem with. however, i am still getting the same error with one of the queries. i tried to create using both the wizard and the manual way but no luck. also, i read in another forum that this may be a...

I split my database so multiple users can acess info simultaneously and now i am not able to open a query in design view. i keep getting an error that says " is not a valid name the same query that is giving me the problem opens fine before i split it. all of the other queries allow me to...

I inserted a RunMacro cmd after my code and had it reset the filter to the date. works fine now.

I have two forms 'employees' and 'residences' in the 'employees' form i have a filter that removes past employees based on a departure date. the filter is: Departure is null or Departure>= int(now()) in the residences form i have a openForm cmd that opens the employee form the the occupant...

Well i found a way to make it all work much more simply just playing arund with setValue marcos. now it does what i need it to do and moves around just fine. thanks for your support though. looks like i still have a lot to learn but im getting there :)

i keep getting a paramete box to input a residence id. fml

should i create another table or just add them directly to the existing tables