Search results

Good day all. Its been a while and what I thought would be a straight forwards fix turns out to more complicated then it should be. I dare say there is an easy fix I've overlooked but having spent yesterday following various leads courtesy of Google I am still stuck on square one! I have a...

Hi all. I have been using PT queries from Access 2007 to SQL 2005 and it has been very helpfull, however, i'm now trying to do the same in order to pull some Data from an AS400 DB so that I can make the user's lives that much easier, however using the ODBC connection string below i'm not having...

Good day all. Been tasked with a rather urgent but time consuming project of catlogging the names of a whole bunch of Excel file names into a table. I'm expected to just copy and paste the names of the sheets to a table but i'm certain Access can automate this boring procedure with just a few...

Good day all. I recently set up one of my Databases (access 2007) to create an ODBC connection to SQL Server 2000 on the fly, using the aid of these two sites/articles: http://support.microsoft.com/kb/892490 http://www.connectionstrings.com/sql-server and all was well with the world, but...

Hi all, I managed to find this nice code that creates a DSN for a SQL server table on the fly for when a user opens a form of the application I have created in Access 2007. Dim stConnect As String If Len(stUsername) = 0 Then stConnect = "Description=SQLDSNName" & vbCr & "SERVER=MySQLServer" &...

Hi all, bit vague this one but i'm not looking at doing anything particulary amazing. I just want to be able to open a form which has the webcontrol open to a particular website, be it google or one of my own and allow me/the user to use it from the Access app i'm developing. Not had any...

Good day all, weird one this and having searched the forums and looked into the 'DeleteObject' method i'm surprised that method does not allow you to delete a field from a table on the fly. I have a process that allows users to import data from a spreadsheet to the DB, then...

Hi all. I have a routine that loops through a table using a specific field and pulls the Daat from another table that will use the value of that field to export the related Data as a Excel sheet. It does this by writing to a temp table before exporting to a specified path as an excel file. So...

Good day all, working my way through a project using Access 2007. not long made the switch from 2003 and finding some of my habits are slowing me down! Usign the Control wizard I'm creating buttons but once it is complete I go to the buttons property in the hope of getting...

Good day all, I imagine this is a common problem but cannot find anything online with what I am hoping is a simple answer. I've been developing this application in AccessXP/2003 and yesterday I was upgraded to Access 2007. Actually my whole PC was swapped out for a new one in...

Hi all, I have a subform control on my main form named subsubform which is a subform also named subsubform. This subform has no controls on it, it is just a placeholder. The subform changes to one of three other subform depending on the button the user clicks so they can see three...

Good day all, i'm trying to grab a string from another string. I have tried using instr, mid, right, left etc..etc but not having any success due to the fact I want the string search to start at the end of the string and go left, stopping untill it finds the first (last from...

Good day all, I hope everyone enjoyed the Christmas break as much as I did and you have my sympathy if you reply to this question today since it may mean that like me you are back to the office already ! Anyway, I do have a problem regardign the DateSerial function. I have a...

Hi all, i've been scratching my head over this one for a while now and hope someone can resolve what I thought would be a simple count solution. I have a number of different fields on a report that is based on a query that has just one record but many fields. The value of those fields is...

Hi all. Having problems trying to list which fields in a table do not have any values in them at all. I thought this would be pretty straight-forwards but i'm having a nightmare trying to put this together. I wanted to create a query then use that as the source for a report. The table has quite...

Hi all, i'm sure this has been asked in the past but not found anything using search so I have a bad feeling this is not possible. I'd like to know if it is possible to code a function that will upsize a table from Access 2003 to SQL server 2000 at the click of a button ? I'd like this...

Hi all, trying to format a date to YYYYMM so it can be used when it exports data to a excel sheet as part of the name, however i'm having problems getting formattting to use a date and format it the way I want, in this example YYYYMM. I tried it and its not working so I tried something...

Hi all, I have a question regarding pros and cons of using Access or Web front-end. We are currently creating a DB which will be upsized to SQL server 2000 for our Dept and another Dept to share/use/update data to. We planned on developing the front end in Access 2003 as it will be...

Hi all, I have a field that looks up two values from two fields and then divides the two values for the answer but of course if one of those values is zero I get the DIV# value, so I am having to check each value to make sure neither one is zero, and if it is then to just insert zero...

Hi all, this could well be a bit of a weird request so bare with me. I would like to view the table size (in KB, not records) and I would have thought the Detail view in the Table tab would take care of this for me (i'm sure it used to, i'm using Access XP now) but I cannot get that...