Search results

Hello All, So my boss has decided to give me some layout advice (poke his nose into a support database) and wants to bring things in line with the latest thinking of MSDN before roll out. To that end I've had to remove the majority of the buttons used for normal database things and add them to...

Hi All, I know this sounds easy to do but let me fill you in on this. So on my tech support DB I have a calendar form, gratefully taken from another (sorry can't remember who). I want to populate the small Green text boxes with the number of Tech support calls we have had in the particular...

Hello all I have a database that looks after our repairs and technical support logging. My CEO wants one of the reports to be exported to PDF but it needs to be editable. My question is: does anyone or has any one done similar? created an editable pdf file from a report or the query under the...

Hi All So not really related to Access but I thought It would be quicker to do this programmatically then by long hand So what I'm doing is kind or related to a Database. We have board that we test and results are recorded in excel spreadsheets like shown in the Excel results image. What I...

Hello Everyone My main customer repairs database has a table for cameras with information like serial number, series, model, sensor type, memory and any additional configuration. I've made a crosstab query below (not got much experience in these) that gives me the result of the camera series...

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

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

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

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

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

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

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

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

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

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