| Thread | Last Post | Replies |
|
| Error question | 12 Feb 2008 22:10 GMT | 1 |
What does the following error mean? "The Microsoft Jet database engine could not find the object "MSysDb". Make sure the object exists and that you spell its name and the parth name correctly.
|
| Access Question | 12 Feb 2008 21:33 GMT | 4 |
I have a table that is automatically generating a date/time based using '=now ()'. I want to create another field that will use the default value to assign the current shift (based on current hour) but allow it to be changed if necessary.
|
| Reports: how do I Group on ranges of hours? | 12 Feb 2008 20:58 GMT | 2 |
I am trying to group on 6 hourly ranges (see below) and have the group/report total the number of log-ins during each time range. I have the report grouping on each client and then counting the number of log-ins during a one day period (midnight to midnight) for each client by ...
|
| items in drop down box are there but not visible | 12 Feb 2008 20:56 GMT | 1 |
My Company is trying out this database program that runs in Access it is Called TEAMS. It is loaded in the computer and has sample information built in we just go back and enter our own info for our company. The problem is in the drop down boxes where some of the categories are ...
|
| Sorting X Axis of Graph embedded in a Form | 12 Feb 2008 20:42 GMT | 7 |
I have months defined in a table that I need on hte X axis of a graph. But the sort order is alphabetic which does not sort by months of the year. I have tried putting a sort order by number; but it doesn't work. How can I sort this with Jan being the first month in the order. ...
|
| Too many many-to-many? | 12 Feb 2008 20:11 GMT | 10 |
To all, I hope you can shed some light on this for me. I am using Access 2003. I have three main tables 1) Project
|
| DateDiff Calculation -hours & minutes | 12 Feb 2008 19:56 GMT | 10 |
Hi there I have a query with a formula to calculate the number of hours a load has taken. It is: =DateDif("h",[Startloaddatetime],[FinishLoaddatetime])
|
| wireless network has to be started every time | 12 Feb 2008 19:51 GMT | 2 |
We switched our wireless encryption from WEP to WPA and I must've done something wrong. But now we need to start the utility every time we boot the PC. Read the over air links, instructions very carefully made several tries, but still not able to get the wireless to come up ...
|
| Using Charts in Groups | 12 Feb 2008 18:55 GMT | 1 |
I'm writing a report that I want grouped by alloy-temper. Using the following query I inserted a chart into the group section. SELECT qrySiFeCuVSyts.[Silicon], qrySiFeCuVSyts.[YTS], qrySiFeCuVSyts.[Alloy-Temper] FROM qrySiFeCuVSyts;
|
| Access shortcust not working after updates | 12 Feb 2008 18:30 GMT | 1 |
Hi, After windows update installed IE7 our shortcuts to Access databases quit working. We need to open access the browse to the db file and open it. Why did shortcuts quit working?
|
| Access2k3 SourceSafe Add-In doesn't work - HELP! | 12 Feb 2008 18:18 GMT | 5 |
I've been asked by a client to upsize his home-made database to SQL Server. The client has no training in database design or application development, and unfortunately he's living proof that a little knowledge is a dangerous thing. The actual application isn't that bad
|
| Access 2007 unusable over network | 12 Feb 2008 18:02 GMT | 40 |
Access 2007 seems to have severe (severe!!!) performance problems with mdb's over a network. Over VPN it's downright unusable. It doesn't matter if the mdb is upgraded or not... and it happens on both XP and Vista and on different machines. I expected the Office Suite SP1 to ...
|
| SQL statement/joining tables when unequal | 12 Feb 2008 17:40 GMT | 2 |
I'd like to join two tables, but I don't have the option to display only those entires that are not in the second table. I've been trying without any success to write an SQL statement to produce only those entries that are in one table and not the other.
|
| Merge 2 tables into 1 | 12 Feb 2008 16:53 GMT | 1 |
I have 2 tables with exactly the same fields so are identical in the way they are set up. What would be the best way to merge them together so i have just the 1 table?
|
| Multiple charts one one report | 12 Feb 2008 16:52 GMT | 1 |
I have created a report which takes data through a select query. Now when i've put 8 charts on the report which also takes the data from the same dynaset of the query. now when i preview report i need to enter the filtering parameter 17 times. How to resolve this ?
|