Search results for query: *

hello, Im trying to setup this DB but am having such a hard time. I have a subform (frmEmployeeFunctionsSubform) and next to each combo box (cboArea) I want to have a text box that says if the employee completed all the requirements for the functional area it will show "completed" and if not...

Hello, I wanted to have my forms Record source based off a selection from my combo box (cboFunction). I can create a query and open the form and make the selection in the combo box and the correct data comes up but I don't know how to execute it in VBA on my form? Below is the querys SQL... What...

Hello, I'm asked to create a database that will keep track of the progress of how many classifications an employee has done in a functional area for a position. Here is how it goes... There are 7 positions and lets say for OP 1 in the functional areas you learned under F1 some of the...

Ok, I have a database at work on our server and only one person is on it at a time and only about 5 people use it total and the odds of two people on it at the same time are slim to none and everyone here has 2007 MS access. Now one of the employees got a new PC with a upgraded version of Access...

This is in reference to thread702-1723375: Yearly calendar for attendance Majp helped me build that was closed. I'm now asked by my all my superior a printout of the troubled employees worked days to date for the year since they dont like to come to work and take days off constantly. Anyways, he...

MaJP, you have help me out tremendously in the past with a similar project (Attendance Database) and im envisioning this sorta like that but not like a calendar but as data. I have attached a image of what I want the form to look like and I think I have the query already done...

Majp, in reference to thread702-1723375 that was closed I remember I asked how to highlight the current day and you gave me some code to do so and I never incorporated it into my database at the time. Im wanting to try it and I dug threw the thread and found the vba below. I cant seem to get it...

Hello, I have a form that has a control and its value is a decimal. I want to move that value to the control I opened from and I keep getting an error: Run-time error '438': Object doesn't support this property or method Debug takes me to my only vba im using on the button on the form...

Hello, I need some ideas on the best solution for doing this. I have a memo field that I need to select from a combo box and display the result in a text box next to it which is easy. My problem is the text being long and the user having to scroll in a combo box to make a selection isn't very...

Hello, I have a completed database and after reviewing and messing with it a lot and trying different scenarios I think I should have a multiselect listbox instead of a combo box on my main form. My question is right now I save my selection my table (tbl_Hold) field (ProductID) and the record...

Hello I have a combo box [cboRejectLotNumber] on a continious form [fsub_RejectedData] and I cant have the same selection used more than once. What VBA can I add that will stop the user and give a message and send them back to the combo box? Thanks! Thanks, SoggyCashew.....

Hello, I have been trying to figure this out and have no clue how to get the value of the last records [txtLotNumber] into the new record [txtLotNumber] using the button cmdCopyLotDown. I also don't want to show the button on the first record because there is nothing to copy down an it will...

Hello, I need to only print the first page of my report using vba and I need to not open the report so it needs to be hidden. I also would like to get a dialog but I cant figure it out... I can get it to print the one page using the code below but it briefly opens a preview of the report so I...

Hello, I know your not supposed to do this and if I could figure out not to that would be way better... I attached my database I have been working on and im stuck and have been for some time on this. What I have to be able to do is email some data using outlook and it could be as an report...

Hello, I have a form that has a formula and this text box is hidden and named txtAutoHeld with a formula; =IIf([cboProductID].[Column](1)="SLOC...

Hello, I used to have a bit of code I found on the net someone wounderfull person wrote that allowed you to requery the form and it wouldnt take you to the first record it would stay on the current record and I cant find it anywhere.... Please help! Thanks, SoggyCashew.....

Hello, First I want to say this code is not mine I have found it years ago and been using it since in a Visual Work Instruction database since to get images for each instruction or step in a process. Anyway, I have a button on my form that has the code below: Private Sub cmdImg_Add_Click() On...

Hello, I am wanting to start a project of putting together a VWI or Visual Work Instruction Database that you would be able to write steps on how to perform a job safely and its hazards and tools needed on each step along with an image if available OR a video if possible on some steps besides...

Hello, I have a continious form thats record source is a table (tbl_MachineOutput) not a query. How can I using VBA have the new record on top and then last record first so I dont have to scroll down the form? Thanks, Thanks, SoggyCashew.....

Hello, I have this database and I’m having trouble figuring out this query that works with the unload event of my [frm_ShiftDay]. Here is how it’s supposed to work…. I open the [frm_ShiftDay] which I select a shift and date and technician and in its subform [frm_ShiftMachinesRanSubform] I enter...