Search results

Hello, Long time, no post! I have a form with an Attachment field on it - this field is used to store user photographs. Once in a while, these pictures are updated, but the old ones are retained too. They follow the naming convention of: CCYY_MM_DD_HH_MM_SS.jpg When there is a single photo...

Hello, Apologies if this is a very simple problem - but it's got me foxed! I am VERY new to ASP webpage development, learning as I go. I have a webpage that retrieves user details from an access database on the web server. What I want to do, is for the currently saved user details (e.g. Full...

Hello all, I am puzzled (as usual)... I have 2 queries in a call logging db, which return a list of events associated with calls be opened, and then the other returns events of calls being closed. qryCallOpenings: SELECT tblIncident.IncidentID, tblIncident.PC, tblEvent.EventType...

I have the following nested IIf statement in an Access query – which works fine, except the final “#NONE#” message. IIf([AccID]="GPEP",3,IIf([AccID]="ISA",2,IIf(IsNull([AccID]),1,"#NONE#"))) The idea is, if [AccID] contains any of the specified strings, or is null, a number is returned (1, 2...

Hello, I have a DB which contains about 110 tables, all have the same fields in (I know, poor design, it is an export from some dodgy 3rd party bit of software). Anyway - I would like to export them all to either seperate spreadsheets, or a single spreadsheet, either as seperate sheets, or all...

Hello all, I have a most peculiar question. I have been working on a database for months now, on and off, and it works absolutely fine on my PC. Access frontend, linked to SQL backend. I have now tried to share this with collegues now, and am getting an odbc error in just one query. I...

Hello all, I need to count the number of groups in a report - to do this, I have a text box in my group footer with a controlsource of "=1". I have then set this to be a "Running Sum" > "Over All". This works great for the report footer, and it shows the number of groups as I want it to. But...

Hello all - long time no see! (lucky for all of you!) I have a working db system that I use a call logging system for an IT helpdesk, which shows the average call resolution time (management just LOVE statistics!). Anyway - at the moment, I am just using datediff functions, which doesn't make...

Hello all, This is likely to be something really obvious, but I can't figure it out for the life of me! I upsized my Access backend to our SQL (2000) server a few weeks ago, and everything has been going fine, I am accessing the data with no problems. However, today, I went to edit one of the...

Hello, I have been working on this for 3 days solid now, and have gotten absolutely nowhere. I am about ready to throw myself out the window! :mad: I am trying to export a Crystal report to PDF from within Access, but I cannot get past this damn message about having a Missing or Out of Date...

Hello all, I am trying to record a whole load of dates into a table (tblOccurences). My code calling a function to whack the records into the table CreateOccurence DecreaseDate(Text0) 'Main Occurence CreateOccurence (DateAdd("d", 1, DecreaseDate(Text0))) '1 Day Reminder CreateOccurence...

Hello all, I am trying to record a whole load of dates into a table (tblOccurences). My code calling a function to whack the records into the table CreateOccurence DecreaseDate(Text0) 'Main Occurence CreateOccurence (DateAdd("d", 1, DecreaseDate(Text0))) '1 Day Reminder CreateOccurence...

Hello all, I am sure this must be simple, but I can't get my head around it. I have a query that looks at client bank account numbers, and finds duplicates. There are a LOT of duplicates, because we have several accounts for the same person. What I would like to do is find all the records...

Hello, In my error handling code, I usually have a final "anything else" bit, which should display a message showing the error number and description. Is there a way to add a button that will bring up the standard VBA "Debug" screen, highlighting the error in the code? Thank you!

Hello, I am sure this must be possible, and can't believe I can't find anything on it - I must be using the wrong terminology! In VBA I would like to use code something like this: "Forms!" & Form.Parent.Name & ".Visible=False" The idea being, that when you click the button this code is on...

Hello all, I have looked, but don't really know what I am searching for - so have given up and am asking you! I have a listbox which lists people's names. This list can be filtered using a text box next door. Often, when you use the text box to filter (for example, you enter "smi" to find...

Hello all, I believe this is an actual tough one, rather than just something I am being thick about... I would like to use the results of a ping in Access. For example, I ping 192.168.2.100, if it is available, and therefore replying successfully, I would like Access to report the address as...

Hello all, When I run a piece of SQL in a query from the access query design view, I get 2 records appear, as I would expect. When I try and run the same thing as a recordset in VBA, I don't get any records. I can't for the life of me figure (or find) out why. The code (including the SQL) is...

Hello I have recently learnt how to use Crystal Reports - and had a basic example built into an access database for me, to show me how to run a crystal report from within access, using the crystal activex control. I would like to (from VBA) export a whole bunch of crystal reports to PDF, and...

Hiya, I realise this could well go against almost every DB rule in the book, but figured I would ask it anyway! I have a database, which pulls all it's data from other databases - some in SQL, some in Oracle, and some from other Access DBs. It then combines it all, performs dozens of queries...