I have been running a bowls club db for years without problem. I now find I am getting an error message whichever report I call. "Please wait for printer connection or cancel connection"
If I click on cancel - surprise - it cancels the request. If I leave it and wait then after some seconds the...
Hi guys
Background:
Every year I receive a schedule of sports matches for the whole division, sorted by date.
(This could be anything eg soccer, but is actually bowls)
First thing I want to do is make a list of my team's matches.
VBA to the rescue.
I examine each line of the spreadsheet for my...
Hi guys, not something I've tried before.
Situation: I play a bowls league, several teams in the league, and the organiser produces an excel sheet showing all matches. In order to compile our club's annual handbook I only need our matches.
Progress to date: Using vba I copy the current sheet (to...
I have two tables, tblCustomers and tblMachines, now all machines should belong to a customer (foreign key), but due to a table design oversight some machines are orphans.
In order for my client to find these I have inserted a routine at the switchboard "form current" event to check for...
Greetings all - it's been a while.
I have a form designed to show records of a customer's machines. I open the form from another form using an SQL string to show the customer's info required. This has a global variable set as SqlSet2=true. The form on open checks the sqlset and opens to display...
HI (again)
I have data to be inserted into record.
The record will be in one of two tables.
I have the vba to update the table by searching the table and editing the field
If the record is not in the second table Access stops at rst.movefirst with an error message. (because no record)
How can I...
Hi all
I know there are some very bright guys out there...
I have inherited a website that is totally suffixed with .aspx, something I know nothing about, and which I am informed has been discontinued.
From a brief and not thorough test I appear to be able to rename them to .htm and then edit in...
I have a table of fund names, these have a changeable value.
I have a table of holdings, so a one to many arrangement.
The main form holds the fund name and value, it ID field links it to the holding table, which feeds two subforms (two investors) showing the quantity of shares held.
What I am...
hi guys, long story, kept short
I am making a copy of an existing db in access 2000, and rebuilding it to Access 2007.
The original has a userform (for my client to select reporting options) in v2000, but I can't see how to make one in v2007.
I found the toolbox - so I know it should be there...
I am trying to get a form to act as a dialog box, but the vba which opens the form just carries straight on.
Background: I have a choice of two reports to select from, called rptOriginal and rptNew. The selection form has two command buttons which set a global variable to the required report...
Greetings again.
I have a report which can be opened to show data from 4 different crosstab queries, the number of columns being dependant on the number of records in that query.
First column shows a list of names, subsequent cols are check boxes under a date heading.
A checked box shows the...
Using Access 2013 I have a continuous form with an SQL string recordsource showing a summary of investments.
The total value of a fund is displayed in a calculated textbox from two other fields, number of units x unit value.
To reset the current value I open a form for that record, amend the...
Greetings all,
Before I go too far into this, are there any known issues with office 2007 running an Office 2000 version database?
Problem was, I thought, a corrupt table in the back end of an Office 2000 db.
My client has just installed Office 2007 (was running on 2000), and accesses the back...
Hi Guys.
I have been sent a scan of a colour photograph which has been left in the sun too long.
Basic corrections like levels are no problem, but the red content has totally faded, so selective red enhancement is not possible. It could be redone as a monochrome print using the cyan channel...
When adding an item to a contract, the item's "notes" memo field is amended.
I want to start a fresh line in the text box, hence the code:
txtNotes = txtNotes & vbLf & "This machine added to contract " & CurrentContract & "on " & Left(Now, 10)
The comment is added, but without a fresh line...
I have customers with contracts and equipment, some with equipment not on contract.
From the switchboard I open a (continuous) form "frmSearch" this is based on a query which asks for a name.
From the displayed names I select one, and I can open another form showing that customer's equipment...
This is silly.
Col A is formated as Date under custom formats (in the UK dates are) dd/mm/yyyy
I want to count the difference in days between cells, so while setting it up B1 = Datevalue(A1)
I was expecting the Excel date expressed as a number, what I got was #VALUE!
While setting the formula...
This has been bugging me for days now, I have forgotten half (at least) of all I thought I knew....
I am attempting to open a DAO recordset [rst] and write the contents into textboxes. The size of the recordset can vary, so:
moveFirst
For i = 1 To totalrecords 'from rst.RecordCount...
I have a table in word 2003.
One column has X in some of the cells.
In a row at the foot of the table I need to count the total number of X's in the column.
I know "=COUNTA(C2:C40)" works in Excel, but can anyone translate this to word for me please?
Telephoto
I know you don't design dbs for questioners - but I have a db, it runs in Access 2003, I just want it better.
Simplified situation:
The db is a record of club sporting events taking place in the current year, there are two tables:
Table 1 contains serial no, date, event name, home or away...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.