Search results for query: *

Hi, I am using a code that use a combo box in excel when there is a validation list in the cell. Everything works perfectly except one thing. When the code is done the cursor in the combobox is at the end of the text. I would prefer the text to be highlighted so I dont have to select it by...

Hi, I would like to know if it is possible to link an Excel sheet in Access without the first 4 rows. I have an excel file wich is use by many users with the header in row 5 and when I link it to Access, the names of the fields change if the first row of the Excel sheet changed. Thanks Frank

Hi, I'm trying to count consecutive data in this table: EmplNo Day Code 1 1 Sick 1 2 Sick 1 5 Sick 1 6 At work 1 7 Sick 2 1 Sick 2 2 At work 2 3 Sick 2...

Hi, I am trying to figure out how to do this query/VBA code in Access. I have a table name tblResults with those fields: fldCompetitionID fldJudgeID fldCompetitorID fldResult The results are ordinal (rank 1st, 2nd, 3rd,...) with no tie allowed Here how the relative placement works: 4. A...

Hi, I am using a VB code in excel, and I want to use the value of a named cell in my If...Then...Else code. I can't figure out what I should use to code it. My cell is name "Test" and my code looks like this: If cell name "Test" = Red Then ..... Elseif cell name "Test" = Blue Then...

Hi, With a barcode scanner I will scan the items that are "out" in my table, as they come back in. After being scanned, I want the items to be update to the new status "in". To do that I created a table with those fields: itemnumber dateout status (in or out) datein Then I created Query1 to...

Hi, I have a database with a table name Schedule wich contains thoses fields. EmployeeNo WeekNo Year Dayofweek (Sunday, Monday,...) Shift (Day, Afternoon, Night) Start (beginning of the shift) Duration (how many hours of work) Description (type of work to be done) Data in that table would...

Hi, I'm trying to add an If...Then code in my report to hide some fields. One the field is a descritption and if its equal to 5, 7, 8 or 10 I want it to be invisible. My code goes like this: If Description1=(5 or 7 or 8 or 10) Then Description1.Visible = False Else...

Hi, I have an employe database with details on everyday of those employes. There is an a particular event that I want to track by date. If the employe has been late 4 times during a period of 28 days I want the report or the query to show it to me. I was thinking of something like that in a...

Hi I have a database of employes and I need to sort them with a seniority number. This number will vary if employes quit or new one are hired. My table looks like this: Dates (the name of the table) No_employe (the primary key) No_union (there is 2 different...

Hi I have a database of employes and I need to sort them with a seniority number. This number will vary if employes quit or new one are hired. My table looks like this: Dates (the name of the table) No_employe (the primary key) No_union (there is 2 different...

Hi I am trying to use a code to clear cells if their value is the same as the P1 cell. The if part doesn't seem to work and I can not find what is wrong. I dont want to use the find and replace option in Excel. Range("D1").Select Do Until Range("D50").Select If ActiveCell.Value = ("P1") Then...

Hi, I have two tables link together with the employees number. The first one, Schedule_defaulft, has one record per employee with their default schedule, the one they usually have. The second one, Schedule_week, has multiple records per employee, each records are their real schedule for a...

Hi, I need a report that will show 8 columns side by side. I use the column setting but now the labels are also repeated on every columns. How can I get the labels on the letf side and the columns on the right side without repeating the labels. This is what I got: week 1 week 2...

Hi, I recently format my hard drive. Now I am triing to reinstall all my drivers to be able to use my computer again. After a few tries and a few problems I notice that when I install the D-Link Fast Ethernet Adapter DFE-530TX (use for my high speed modem) and the Soundblaster Live! Value...

Hi I want to be able to change the current user without closing the database each time. Is there a way to add a button that would logout the user and prompt the message box to login another one. I really need a qick answer. Thanks

I dont want to use the navigation bar in a form, but I want the user to know how many record there is and on wich he is working on. I create an unbound text box with this code in the control source. =[CurrentRecord] & " of " & Count(*) Its working well, but if I add a new record the...

I have a code that is suppose to work. I have a country (Pays) table and an agent table, I want to change the imputmask of the zipcode (Code Postal) if the country change. I have more than 50 countries in that table so I dont want to use if then 50 times. The country tableis like this: ID...

Hi I am using a some form that open with DoCmd.Maximize but the problem is that I also have other forms that would be best viewed in the normal size. Example, inside a client form that is maximize i have a button that can open a small form to make little corrections by adding new choice for a...

I need to use different imput mask depending from wich country my client is from. I would like to have a zip code and a phone number imput mask that change for each country. Someone told me to put an "if code" but the problem is that the database is for a travel agency. We have...