Search results
-
H
Macros
Hello I have set up a macro that will run several queries that I have in my database. I also have a form set up. At the top of the form I have a text box where you enter the date that you want to select data for. This is referenced in to each query - so that you need to enter a date in the... -
H
Width of forms
Hello Very simple problem. I have a form in design view and I can see that it is only 10cm wide. However, when I open it in form view the grey screen goes on all the way to the end of the screen. How do I change the properties so that it only shows what I want it to. I have tried going into... -
H
Not enough disk space
Hello I have two tables in access. One is the main table, where all the data is stored. The other table is the import table, which is where the data is loaded & updated (records are deduped, suppressed etc.). I am trying to load 300,000 records into the import and main tables. I have a... -
H
Update Reference Numbers
Hello I have 18,000 unique reference numbers in a table that I need to amend. The ref nums are all 16 digits in length and they all start 8243161.... then the rest of the 9 digits are all unique. However, the number 161 needs to be amended to 141. The rest of the number all needs to stay the... -
H
Auto Number/number
Hello I have got a database that has got a few different tables in it. The first table consists of a list of all records with contact names, telephone number, address etc. I have allocated an auto ID number to this field so that it has a unique ref. I have done a few update queries on this... -
H
Scorecard FORM
Hello I am having difficulty setting up a form to record quality scores. Originally I had a spreadsheet set up which had a drop down list for each question and then if statements in another cell which would give each question a mark depending on the answer (e.g the drop down list would have... -
H
Concatanate two fields
Hello Is there a formula that I can use that will put two fields together. At the moment I have two fields that are separate but need to be put together in an extract file. i.e The first field has 4 characters and the 2nd field has 3 characters, I need a formula that will join the two... -
H
Strip Query
Hello I am having problems with a strip query. I am trying to export some data from access into a text file. Operators using the front end screen of access enter the full workphone into the workphone field, however, the text file must separate the std field from the rest of the phone field...