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

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

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

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

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

I have a combo box where you can select a residence out of and 'available residence' query. i created a yes/no column to indicate when a house was assigned and placed it in the 'employee' table that the available query is based on. when i click the residence in the box it goes into a field...

I have a form that lists data about current and incoming employees. for the incoming employees that need to be assigned housing i have a combo box that lists all available houses for the year. these houses are those that belong to departing employees and are up for reassignment. after the...

I have two main tables: 'employees' and 'residences' I have created several queries including one that lists all the employees leaving in the current year and their residences. there are two forms, one for each table, where new info will be entered to update the tables or add new records. the...

i am currently working on a form where i have a new employee arriving that will be staying in a departing employees house. in the form i have an employee that is going to arrive and several bits of info, including his permanent address (to be assigned by me). when the employee arrives there...

I am a n00b with VBA and need some help. I have a form that lists data about hundreds of employees. in that form is an address column that is also in a residences table. I put links to google maps for each address in the residence table. I am trying to develop a button that on click will go...

I am currently working a a project for a housing board and I have two tables, 'employees' and 'residences'. i have a form off of the 'employees' table that is where the housing board will work off of. it contains information like 'employee', 'permanent_address', 'zone', etc. I wanted to add a...