Search results

Afternoon all, I am using a 2003 Access DB on Windows 10 (I have Access 2010 as well at home on my laptop but need the query to work on a 2003 instalation). I have a table (tbl_myDB) with one of the columns as class these can be 01, 08, 10, 47, 56 and multiples of these. I have a table...

Morning all, It's been a very long time since I have done anything in Access and despite googling I cannot see the answer I need, so I hope someone can help with this. I have two tables (mydb and tbl_Repairs) that I need to use to produce a form of. In tbl_mydb and tbl_Repairs I have field...

I am stumbling today badly Sorry for these dumb questions. In column D I have a date (different on each row) and in Column E I have another date (again different dates on different rows) I need Column D conditional formatted to that If the date in column D is less than Column E then it turns...

Hi, I want to query a table in Access 2003. I have set up the query and under criteria I need to to just select the items that are due for review. the items that need to be reviewed need to be done 21 days prior to the expiry date. i.e. Item 1 expiry date = 31/07/2015. The query would show...

Hi all, Currently this is in the theory stage of a DB I am planning, if I pursue the DB any further I need to know if I can do this. I am hoping to create a Database but from the the data within a table I need to create a web page. I know that you can save a table as a webpage but we...

Hi all, I know that excel had a built in function to create a web page but it is not what I need allow me to explain. We have an intranet and I am fed up of the link going to a excel that has been set up as a htm file. Frequantly columns are collapsed and ruin the data contained within the...

Hi all, Hope someone can help me. I am in need of assistance with the creation of VBA code thaat counts cells that have certain criteria. The background (interior colour) is = 35 and the cell contents need to equal a named cell called filename. In laymans terms if it were a formula would...

Hi all, I posted to another part of the forum but I havwe managed to locate some of the answers to my original post yet this one seems to allude me. In my DB I have a query that I need to create a static webpage from, now in excel I can do the record button and bingo, but access is a lot...

Hi all, I have a question related to a textbox on a form. In my table (tbl_data) I have a field named Rating. This can be anything from 1 - 10. On my form (frm_input) I have a textbox (created using the wizard so at the moment I'll call it txt_Rating). What I would like to know how to do...

Hi, Hope this makes sense and it is in the correct section. I am using Access 2002. I am going to be producing a macro that imports a txt file. Once the text file is imported there will be a empty field for a date value. Nothing in the file that is being imported will have a date in it. I...

Hi all, Can you guys help me out with this. I want to create a form in Access 2002 (old I know) that displays the following items. txtTotalRecs: This is ALL the records in the tbl_CoreDB txtTotalATH: This is the count of all records in the tbl_CoreDB in the field LGE that meet the criteria...

Hi all, This is probably very basic and I am missing somthing really obvious. I have a custom toolbar with a button on it that I want to open a userform from. I have tried this macro Sub Admin_Show() frmAdmin.Show End Sub and the button on the custom button calls the macro with...

Here I am again folks looking for help please. I have a Access 2002 DB. In it I have a table called tbl_StartingXI. The fields are: MatchID, Player, TimeOn, TimeOff, Yellow, Yellow_Time, Red, Subbed, Replaced. I have a qry_CalcTimeOn and another called qry_AddUpTime Using the queries, the...

Hi, I hope someone can point me in the right direction. I have a Access 2003 DB in it I have a table (tbl_Coredata) in the table are the fields Season, Date, Home, Away, HG, AG, (plus some others.) I want to have a form created that has a combo box on it. When the person chooses a value...

Hi, If this is in the wrong section, sorry and please fee free to move it. I have a vbscript that creates a html output from a table in access 2003. What I would like to know is how to execute that vbscript from a button? OR Is there a better way i.e. copy the script in to a...

I have attached a screen dump of my problem. I am trying to count the number of cards in a game in a query. The check boxes are ticked when a card is issued, but when I run the query (on the right) it shows a minus figure .... How come. Please can someone advise me what's wrong. Using...

Hoping someone can help me out here. I have searched a bit and I have some answers but I need a little clarity if possible. I have a Access 2003 DB and in it I have a table called tbl_NFM In the same directory on our network I will bve having various csv files that I wish to import in to...

Hi, I have a form for searching a table. On the form is a combobox (cboSearchStation) that is populated with all the station names in the table. What I need it that when a user selects a staion name it populates all the other controls on the form. (See image). I have tried a few serches...

Hi all, I have Access 2003 and I have two tables in it. I need to import/copy over selected data from one table (Station Data) to the other (tbl_Stations). You can see from the attached image the tables the fields I wish to import into table tbl_Stations. 3-Alpha, TIPLOC1 thru 4 Easting...

Hi, I have searched through here and I think I am missing something. I am using Access 2003 and I have a table called tbl_22 Fields are: ID | Location | Miles | etc. i.e. 1 | London | 0.00 | etc. 2 | East Croydon | 10.50 | etc. 3 | Gatwick | 26.68 | etc. Or my form frm_M_Calc I have...