Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: telephoto
  • Content: Threads
  • Order by date
  1. telephoto

    Report waiting for printer before displaying results

    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...
  2. telephoto

    If...Then routine not recognised when it should be

    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...
  3. telephoto

    Pause vba and select cell as value for variable

    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...
  4. telephoto

    How to force a switchboard to refresh when closing another form?

    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...
  5. telephoto

    Data entry or data view? that is the question

    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...
  6. telephoto

    Error trap if no records in recordset

    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...
  7. telephoto

    Can I convert .aspx to .htm?

    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...
  8. telephoto

    Main and subform investment calculation

    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...
  9. telephoto

    Userform required in Access 2007

    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...
  10. telephoto

    Pop-Up? Modal? or something else?

    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...
  11. telephoto

    Counting checked boxes on a crosstab 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...
  12. telephoto

    force recalculate on return to continuous form

    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...
  13. telephoto

    Office 2007 incompatibility with 2000?

    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...
  14. telephoto

    Faded photograph repair

    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...
  15. telephoto

    Putting a line break into a memo box

    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...
  16. telephoto

    Sometimes Form closes, sometimes it doesn't. Why?

    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...
  17. telephoto

    Datevalue(cell ref)=#VALUE!

    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...
  18. telephoto

    There has to be a way - to iterate

    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...
  19. telephoto

    Word table, counting occupied cells

    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
  20. telephoto

    Clud DB - has to be a better solution

    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...

Part and Inventory Search

Back
Top