Search results

Hi, I have a form that I use in my access database. I choose the names of the individuals and hit the send button. The button has the below I want to add to my vba code a voting option that's say "Review with comments and Review with NO comments. Can I do that? as I send a lot of emails...

Hi, So I have this database and I am trying to create a way to update a subform using criteria from the combox in the form. I have been thinking about how to go around accomplishing this and couldn't make it work using the queries (I might be wrong). I believe a VBA of some sort might be...

Hi, I have been struggling to get this to work. So hopefully someone can guide me or help me out with this I have a table called tblSupplierAddresses with 2 columns "SupplierName" and "Address" I have a form which has a subform and both are called "frmMatRRSubform" and "frmDMRSubform" In...

Hi, I am trying to create the attached chart using access. Below is the query I have so far SELECT Abs(Sum(IIf([DurationOpen]<=30,"1","0"))) AS [0 - 30 Days], Abs(Sum(IIf([DurationOpen]>31,"1","0") And IIf([DurationOpen]<=60,"1","0"))) AS [31 - 60 Days]...

Hi, I have been trying to make this work for 3 days and hasn't been successful. I have a form and a subform and within the subform I have a button that allow the user to create a report. The report also has a subreport. All works great when the subform which in turn the subreport have one...

Hi, I have created a database to track the training competency matrix. The way I did it is using the crosstab query. The database is working fine but I spend a lot of time doing manual stuff for the report as my column numbers change. Let me explain. I have lets say 10 manufacturing areas...

Hey, I am working on a database and one of the tables is tblemployee which had the following fields - Name - Department - Date of Hire - Date of Transfer - Date Inactive Also I have tblemployeeArchive which have the following fields - Name - Department - Date of Hire - Date of...

Hi, I been trying to come up with ideas but so far non is giving me the outpu I want. I am trying to create a query to find duplicates and delete the duplicates. The result will eventually be used in another query (append query) to update a table. So let me shed more light on what I am...

I have been testing my database and have found an issue when using one of my append query. Everytime I run the append query (On Close form event) I am ending up with duplicates but I want the append query to be smart and only append those rows that are not equal in tblRecords. Example...

Hi, I been looking around the forum but cant get or pinpoint the way I need to go about this. I might be complicating matters but if it is the case I am sure someone will tell me so and guide me in the right path. I have 2 tables tbltest and tbltest1 both have the same field names lets say...

Hi, I believe I did this before awhile ago but for some reason I keep getting an error. I have a Mainform (frmMain) that has a Subform (frmSub). On frmSub I have 2 comboxes (strCom1 & strCom2) one is set to invisible (strCom2.Visible = No). So using the "On Open Event" of frmMain I want make...

Hi, I am working on a training database and I just cant get the logic to work the way I want it. A couple of things that the database need to be able to handle is: There is something called Modules. Each Module consist of certain documents/work instructions. Each employee will be required to...

Hi, I have a query currently with one word search criteria. So the user can enter a word and the query will bring out everything equal or similar to the word entered by the user. I am using Like "*" & [Forms]![Search]![Text1] & "*". So far so good I was asked if I can allow the User to run the...

Hi, I have been working on this for few days but I dont seem to figure out what I am doing wrong and why I cant get it to work. When the user opens the report (rptSchedule) a form (frmPrintEmailPopup) is opened infront of the report. The form has 3 buttons: Email (works with no issues)...

Hi, Well I am getting stuck or maybe looking at it in a wrong way. So will appreciate any comments/feedback or help on this matter. I have attached the database if someone have time to look at it. Well I have a table that list all the Suppliers critical and non-critical "tblAVL". I have to...

Hi, I created a database to eventually replace the paper forms. So each record in the table (tbldata) represent a paper form completed by a USER. Each record in tbldata is represented by a unique number for example 11-0001, 11-0002, etc where the first digit represent the year and the other...

Hi, I am trying to design a database (Access 2003) to use to track training. I just cant get the tables/forms/query to work like I want. I feel I am missing something. As I said the database is mainly used to track training of individuals by being able to print reports and ensuring if all...

Hi, I have a weird issue happening and I cant get aound it because it doesnt make sense. For the sake of simplicity. I have a report with one field (Date type). Also I have to fields on top of each other one is a Label and the other is a textfield My intention is if the Date field has a...

I dont know how to tackle this. I dont know if is is possible even. I have a Form and in the form I have a Subform (View=Datasheet). On the form I also have a button. What I m trying to do is if someone highlights a record on the Subform and click the button on the form. This will open...

I have been working on this database for a while and now I am at a point of figuring out how to approve the form/Record by multiple users. I have something put together but I dont feel it sufficient and hence, any ideas recommendations will be greatly appreciated....... This what I have so...