Search results

Hi Guys, I am having difficulty trying to figure out how to deign a field using a single combo box, below is the structure: Field: Ethnic Background Possible Selection(s): - African/American - Native American - Hispanic - Caucasian - Pacific Islander + Chamorro + Palauan + Yapese...

Hi Guys, I need all the help, again a non-profit org. asked me to create a DB that can house information to all its clients. But the catch is that some staff needs to go on-field service and needs the DB for editing and/or adding new records. I never tried replication & synchronization so it's...

Hi Guys, Nice to be back again, as always I am in need of help :( I have 2 tables namely: JobVacancies & JobCandidates both of which has common memo field type, AvailablePosition for JobVacancy & PreviousPosition for JobCandidates. Now I want to create a query to search the available...

Hi Guys, I have this problem that really took meoff the hook for quite sometime now, I almost surrender on this task, so please bear with me and your HELP is really appreciated. Here it goes.... I have a table which consists of DB Users (User Name, Password, User Level), also a table for...

Hi, Can someone help me how to reconcile the query results into one to create somewhat of a pop-up reminder. Attached is the DB of what I have so far, I am able to extract the records as well as filtered the data, but I can't figure out on how to fit the results into one column. What I am...

Hi, Can someone help me how to reconcile the query results into one to create somewhat of a pop-up reminder. Attached is the DB of what I have so far, I am able to extract the records as well as filtered the data, but I can't figure out on how to fit the results into one column. What I am...

Hi Guys, I have 3 tables: tblEmp (Employee Table) EmpNo (PK) EmpName (Text) Address (Memo) Phone (Text) HireDate (Date/Time) tblAssignments (Assigment Table for the employee) EmpNo (Text) Client (Text) Location (Memo) TicketDate (Date/Time) Done (Yes/No) tblEmpMemo (Employee's Note)...

Hi Guys, I have a form that has a tab control with 12 pages, I also have a label box. Now I wanted to change the label everytime I select pages on my tabl control. I am using A2K3, any help is appreciated. BTW, I tried the On Change, OnClick event of the tab control. Thanks a lot. Jeff

Hi Guys, How do I implement a user form to relink .dbf file? I found a lot of relinking solutions but all of them I've read was for .mdb. I uses 2 .dbf in a query to extract data and print reports, but I wanted to make a user form so that whenever problem arises (server changes, folder...

Hi Guys, Attached is a DB created on A2K3, I was creating a report with 6 records in a sheet of paper (everything works well) now the problem is, I wanted to create a note on every every record printed on the back of it, the reason for that is that when the user prints a batch of records it...

Hi Guys, I again need your expertise, I now have a problem formatting the report, below is the table structure: Case_No Seq_No Auth_Rep 0001 01 John Doe 0001 02 Jane Doe 0001 03 Jhane Doe 0002...

Hi Guys, I wanted to seek the help of the Guru's with regards to the problem I am dealing at present. I am facing this difficult problem so far, I need to create a form which required the following entry: PC Model Score AXD125 34 MRT665...

Hi guys, This is the really big frustration I had so far using Access 2007, I converted all the applications I created in Access 2K3 to Access 2007 because of the free deployment feature, since I mentioned on my previous posts that the "new guy" then always messing around my code. So...

Hi, As usual I am here again to seek help and guidance to the Masters :). Ok, I'm using Access 2K7, I have an unbounded "Main Form" which houses a Tab with 4 pages, on each pages is a datasheet subform. Now I wanted that when every time I switch pages the datasheet be requeried, I tried...

Hi Guys, Attached is an Access 2007 DB which I am experimenting right now, I am lost on how to open the frmContactDetails based on the selected hyperlink on the frmContacts, I created a macro to open the form but it shows the first record not based on the selected value on my frmContacts. BTW...

Hi Guys, I would like to request the community for their help on this one. On Access 2007 there is this cool feature when you open the supplier form, its a datasheet view, when you add a new record all you have to click is the "New" field on the ID. My question is that how it was implemented...

Hi, I stumbled upon a site (http://www.access-programmers.co.uk/forums/archive/index.php/t-146119.html) and have this code tested: ... As to your problem. Create two fields in your table: TheYear - long TheSequence – long Then enter this code in your form's BeforeInsert Me.TheYear =...

Hi Guys, First, I want to create a sequenced number to be placed at the end of a time stamp then after every end of the month this number will reset again to 1. I've got the time stamp working but can't figure out how to include the sequenced number & reset it to 1 after every beginning of the...

Hi Guys, I have a new task which is to design an order tracking for our company using the attached excel format. Having hard time normalizing ang designing the interface since the user requested the form to be as easy as the excel since they are used to it. You help is highly appreciated...

Hi Guys, Been searching on the forum and on the web for a week now but seems cannot find the solution on my problem. Recently deployed an application in our office (Order Tracking) works well then a new guy came and set his screen resolution to 640 x 480 coz he has having problems with high...