|
Assign value based on value field in query I'm making a query where I want to create a new column with a value based on another columns content The source will contain either of 4 3-letter acronyms (RTB, MIA, RES, KIA). the new coumn should check this and assign a value of 1 for RTB and 0,5 for all others. How would I do this? ... 13 Aug 2010 21:13
MSACCESS.EXE Hung Process I am using version 12.0.6535.5005 of the msaccess.exe executable on a Windows 7 64-bit computer. Every time I open and exit Access, the GUI will be made invisible, but the process is still running in the background. This occurs even if I do not open any database files-- simply opening msaccess.exe and closing it... 13 Aug 2010 17:56
Function to Return the Location of the Backend Hi All, My tables are linked to a Backend called DMS.mdb in: S:\General\Databases\DMS\DMS.mdb Could someone give me a function which would return the full path to the backend, including of not including the db name: msgbox "Location of Backend: " & FunctionName Thanks, Barry ... 13 Aug 2010 12:28
Database Reference info via VBA I've got as little form that will list all the references a database has selected in a textbox, because we all know that when you click Tools/References in a VBA Editor window you sometimes can't see the whole path. My question is, is there a way to see the nice definition that the References dialog box shows? ... 13 Aug 2010 11:23
Verifying Access Version used for currently open database I want to write a line of code to check the version of MS Access being used by my clients, some of which have multiple versions installed. I am distributing my application as an Access 2002 runtime, but want to know what they're running it on. -- Bob Darlington Brisbane ... 12 Aug 2010 22:26
Import DBF files to Access 2003 I have hundreds of dbf files to import from a folder to a table in access 2003 and or 2007. At present I import each file as a table then copy and paste to a master table. For other imports (text, excel etc) I have a macro to import all files in a folder, but I have no option to import DBF files, Anyone able... 12 Aug 2010 16:58
Domain Function Builder -- Access Add-In I got quite used to using this Add-In for Access97. I haven't been able to find an Access2007 version as of yet. Anyone know if this is available? Already tried to add the A97 (MDE file format) version, but the program complains that it was designed for a previous version and the attempt fails. ... 12 Aug 2010 20:16
Control of allowedits when changing views Access XP. My form has tabs, two of them have a subform (frmCarDet that can be edited or not, and frmEventLog always editable). When there is a date in closedon, "allowedits" is at false. Everything works great as long as I stay in form mode. I added the possiblity to browse quicker by using the datasheet mo... 12 Aug 2010 15:51
2003: Table Field Type For Beeeeg Decimal Numbers? For dollar/cents amounts in the billions I've been going on the assumption that Double is the only game in town. Ditto share amounts in the billions with up to 4 decimal places. Bad assumptions? -- PeteCresswell ... 13 Aug 2010 21:13
I am officially SPOOKED by Access 2003 behavior....... Hi Everyone, I am hoping someone can shed some light on what I think is abnormal behavior. I am in the process of wrapping up some reports and letting a user run the report from a command button. Seems pretty simple - you'd think. The data used for the reports is based on a single table. One of the fields is ... 13 Aug 2010 07:01
Link Unicode File I am using Access 2003. Try to link to a Unicode csv file supplied by a website host. The result is a linked table with one field named '￾âåæ¤çæ°æââ°âäæ¤çççä¸ææ´æ ââ°âä´æ¤æææ°æä¸ææ´æââ°âåæææ¼æ¸æä¸ææ´æââ°âäææçãââ°âäææçã... 12 Aug 2010 08:10
Oracle PL/SQ L , Toronto, ON, Canada Title:- Oracle PL/SQL Location:- Toronto, ON, Canada Duration: 6+ Months We are looking for a Oracle Database Programmer with programming 70% (PL/SQL, triggers, and stored procedures) and with database design tools (30%) ER/Win OR ER/Studio. RAC, DSS, OLTP and dataware house experience is a must. Descripti... 11 Aug 2010 19:07
Data from linked table in form Hi! I'm making a for for logging awards for players and I want it to show the award images as I select the award. I use two tables (the log and the award one) and wonder how to link this up. Table 1 is Log, primary is a running count foreign key linked to Awards is the Awardname Awardname have a lookup func... 12 Aug 2010 16:58 |