Search results for query: *

My situation that I'm very puzzled about is... I have a project management database which has correspondences as well as projects. I'm trying to Have a way for Correspondence Item be related to Item 2 & 3. I'd also like to have Item also related to Item 4. All of them have a unique Primary...

Hello, I have a database that I've used user level security where people inputted a username/password to allow them in. We've upgraded to Access 2013 & I wanted to use simply a users table that uses the their network logon as their username. For instance... The windows network logon on...

Hello, I have projects database that the users need to be able to upload & download types of files, like pdf's & jpg. I have made a database before that allowed you to upload/download files into the database, but that quickly 'bloats' (Makes the database huge) All my users have access to a...

Hello, I have a function with an if statement. If a certain value is present, then I want this function to call another one in the same module. Is this possible & how? Thanks, ~roystreet

Hello, I have a system in which makes project number by running a vb function. Here is the function below: frm.txtUniProjNum = Format(Nz(DMax("[tbl_MasterProj].UniProjNum", "tbl_MasterProj"), 0) + 1, "0000") UniProjNum is a text field in tbl_MasterProj. The numbering has worked...

Hello... ..I have never tried this, but is there a way to have access export a report into an existing word template? For instance I have a word template which has a special header & footer. The header changes on all pages after page one. (It is a document that I did not make) Is there a way...

Hello, ...I have 2 tables that contain data for projects. table1: tbl_MasterProj table2: tbl_ProjModel They are related by UniLMN -aka Project Number. There is only one record per project in the master proj table. There can be multiple records per project in the proj model table. The proj...

Hello, Here is a challenge for those out there that know queries well. I have one table that contains the following fields: ProjNum, MakeModSeries, ID, Reg, & Part There can be several MakeModSeries per ProjNum. Each MakeModSeries has it's own ID, Reg, & Part values. Essentially one...

Hello, I have a report that is running smoothly. I am able to export it to word. My report contains a logo on it. Once I try to export it to word, it loses the image. Is it because access only exports rtf? Which I assume doesn't include images? Is there a way I can export into word &...

Hello, I am trying to populate fields from one sub form to another via a click of a button. I'm not quite there yet, trying several things it hasn't worked. I have searched through the forum & I just don't see what I'm looking for. I'm not trying to pass values from the parent to a sub...

Hello, I have 2 tables I'm combining which contain 2 columns each. Both have one common column named ProjectNum. They both have same amount of records (503 records) I am trying to use a query to put them all into one table matching the project number. When I do this, it brings a result of...

Hi - I have one combo box that shows values from 5 fields. 2 of which are important: POC name & Company name. I would like to populate 2 fields via that combo box...Is this possible? The main field needs to be POC name, but the 2nd field needs to be company name. Can I do this? POC field...

Hello, I am using server 2003 R2 & I have found an issue that I can not resolve & didn't know if anyone can help guide me. I have created a group called Sysmods & have given them full permissions on a specific partitions - For "This folder, subfolders, & files" Now when I drill down & go...

Hello, I have a AD users that of course can log on to all of the machines on the directory. But when they log on, they are only given a basic user rights & not an admin account on their local machine. Is there a way I can setup the user so that they become an admin on the workstation they...

Hello, I just created my 2003 domain & am using AD. I wanted to it set up to run a bat file mapping a couple of server locations as drive letters on their local machine. It seems when I try to run it, it states there was an error loading the roaming profile. Similiar script as follows: I...

Hello, I'm not sure if it's windows or MS Office, but I'm pretty sure it's windows. I have several word documents & I've noticed after a short time some of the files have the archive attribute added to them. I'm not sure if there is a setting somewhere, where I can change it so that windows...

Hello, I have a SimpleTech network drive on my network. At one time when I used XP on my machine I can map the drive as you would usually map a password protected drive - No problem. Now I have Vista on my machine & I try to map a password protected drive, it will fail. I believe it has to do...

Hello, Here is my scenario & I am very open to sugesstions. I have a projects DB in which each item has a unique item number generated via VB code. Although these items vary in priority & that can change at the voice of the boss. So this means that not necessarily does item 303 have to be...

Hello, I am trying to allow a user to select Ascending or Descending via a form. Currently, I have a form that allows the user to input a FY (Fiscal Year) value. The report then opens pulling only those records that meet the FY value you selected. I would like the form to allow the user to...

Hello, ...Currently I am working on making the process of inserting an object (mainly word docs) in a DBase. The 'attachments' actually get inserted into a linked DBase. I am not concerned with the amount of space (memory) used by actually importing & not linking images to records. When a...