Search results

ok...provocative title I know. ;) I'm working on teaching myself php/mysql and have gotten some functional php scripts working on my local copy of WAMP. I can get query results, and do basic insert/update etc on a mysql database. The problem I'm faced with is wanting to write a php page that...

Hi, this has me baffled. Not sure if it is a vba thing, a form thing, or something else. I have a single user AC2K database with a Menu form set to open on startup. When the database is opened, the Menu form opens correctly but none of the VBA code in various events associated with command...

Has anyone else here been following the DRM restrictions for recent game releases to PC like Bioshock and upcoming ones like Mass Effect and Spore? I was so excited for Mass Effect I'd actually pre-ordered the darned thing (first time I've ever pre-ordered a game). Then I found out what they...

http://www.telegraph.co.uk/news/main.jhtml?xml=/news/2008/04/24/nogc124.xml Had me laughing so hard when I saw this on the news :)

Does anyone know if there an access equivalent to the SQL server 'unpivot' command relating to crosstab queries or tables?

Hi all, my local university is offering a SQL server 2005 class starting this winter. I am contemplating whether or not to take it and was wondering if anyone here had done something like this? How much of a stretch is it to make that transition if all you know is Access? Would appreciate any...

I am developing a db in three parts: one each to be hosted in two different agencies, and a third to be hosted by a third-party which combines the data from both of the others in one place. Because there is no common network I need to export data from each of the two agency db's in some form...

Hi folks. I'm having an issue with some nested select case statements that aren't returning the expected result the code is in a public function called QualityAssurance and the top-level select case appears to be working correctly because the result is coming from the appropriate part of the...

You know, it just occured to me that it is somewhat odd that this forum, which is dedicated to the intricacies of db design, lists the current post-count for a user next to each of their posts, instead of their post-count at the time of the post. If I were designing it there'd be a junction...

There are times when it is just necessary to have a little rant, a canniption if you will. For the last few weeks I have been working off-and-on with a new database for a salmon hatchery. One of the forms I designed contained a subform in continuous form view that flickered inordinately when...

I've searched but cannot seem to find the right terms to find what I'm looking for. Here's my situation. I've been asked to develop a db for a salmon hatchery. As part of this we've developed some field forms to make it as easy as possible for the hatchery staff to use at various 'stations'...

I am developing a database to track fisheries regulations. Basic data structure is: tSeries(1) - tRegulation(many) tRegulation(1)-tOpening(many) tOpening is the one-side in one-to-many relationships with detail tables like tFisherySchedule, tGearType, tRestriction etc etc. I have a main form...

I have a continuous form bound to a table containing a number of records pertaining to water quality sampling. One of the fields, Activity_category has a conditional formatting condition that counts records in the table that are 'duplicates' with regard to 4 of the fields in the table...

Hi all. For fun I'm embarking on a little db project (need a life methinks). Basically it's for a combined dog kennel and dog training facility. Now, I'm aware that there's been a lot of hotel booking questions on this forum which are usually greeted with 'look at the sample database section'...

I had a couple of forms go corrupt in one of my databases this morning, which has around 50 or so tables in it. I repaired the database by creating a new db then importing all the db objects from the original and the 2 corrupted forms from yesterday's backup. However, the relationships table is...

I am writing a module to calculate the geometric mean and percentile for water quality data. I wrote a module using hard-coded queries as the source for a recordset and it all worked fine. However, I want the user to be able to select how many samples are to be included for each calculation and...

This is not a question. I have recently been playing with exporting a query to a delimited text file and have learned some things along the way. Some of this is bound to be old-hat to some of you. However, I thought that it might be useful to post a summary of what I've learned for the benefit...

I have a complex query that I am exporting to a tab delimited text file. The query has three date fields, and a time field. The query export results in both the date and time portions of the value being shown instead of one or the other. I have tried using the format function to force the...

I have been working on a database an came across an interesting 'glitch' that is beginning to annoy me. I have an unbound combo box on a form bound to a table of land parcels. The combo box was created using the wizard so that I select a parcel number from the drop-down list and the form...

Our organisation runs access 2000 on a citrix server farm...essentially, the computer you use is just a screencapture of access running on a remote machine. Now, in the interests of saving bandwidth the IT department has turned off all audio functions on the citrix server farm preventing me...