Search results

  1. C

    Change BackColour of Form

    Hi all I'm not sure if this has been posted before but I couldn't find it. I did try to post it yesterday but it seems to have disappeared. I've done this before but can't get it working and can't remember how I did it before. So I've got a continuous form that I want to colour code based on...
  2. C

    can't figure where I'm going wrong

    Hi Guys I'm trying to set a recordset as below Set rs = db.OpenRecordset("SELECT * FROM Tbl_Tickets " & _ "WHERE ((tbl_tickets.[DateOpened]) LIKE '*" & CmbYear & ")", dbOpenDynaset) But I keep getting a run time error of 3075 which means I've got the syntax wrong but can't see...
  3. C

    Calendar View Form

    Hi everyone, My main database for work has a calendar view form I developed years ago which populates text boxes on a form based on the underlying table for technical queries. The form has 42 text boxes which are enabled depending on the start day/end day of the month - see my attached shot to...
  4. C

    Report Aspect ratio

    Hello everyone Don't you just love it when someone finds something new to do with a standard report you make? Anyway my boss now wants a previously print or preview report to be displayed on a screen in the Engineering office. Not a problem I think, just export to PDF, which works a treat...
  5. C

    Easy Thing just stumping me

    Hi Everyone I've got a module that populates several date boxes on a form based on the history table. Not difficult I hear you say...However I just can't see what I'm doing wrong I keep getting an error saying Too Few parameters Here the code I'm using to find the dates Set rs =...
  6. C

    Linking tables

    Hi All I'm trying to get access to link to the Back End tables, no problems there..usually StrTable is a passed table name ("Tbl_Version") I've set a variable VarRet as Variant and I'm using VarRet = CurrentDb.TableDefs(StrTable).Fields(0).Name If Err <> 0 Then CheckLinks = False Else...
  7. C

    Azure SQL Gateway/Data warehouse

    Hi all Has anyone had any dealing with Azure and connecting to tables. I'm trying to research ways of connecting my database backend to people in both the UK and USA any ideas or guidance would be gratefully received. Some have said a mixture of VPN and Citrix/Terminal Server, but on the...
  8. C

    Changing Colours on Forms

    Hello everyone, I'm quite advanced with writing my Technical Support database, so far that we are about to roll it out to users in the States (using a mixture of VPN, form timing and other things my IT bod has helped with). It has been well received but now one of the test users has said...
  9. C

    Can you change a Chart title via VBA

    Hi Guys Got a problem that I can't seem to solve. I don't use charts/graphs very often but on my latest build I'm taking support tickets and counting by month and year. The year of interest is selected on a form using a combo box. Some queries then sort the data to what I require. what I'm...
  10. C

    Linked Tables Closing Access 2013

    Hi All I've got a BE db for my front end, I have a splash screen that just shows the db name and welcome message, times out and opens a switchboard. the problem I'm having is that even though I have specified the linked table location as \\server\foldername\subfoldername\BEname.accdb when run...
Top Bottom