| Thread | Last Post | Replies |
|
| Access DDL with DAO | 20 Apr 2008 09:53 GMT | 1 |
Team; Does Microsoft Access (JET) support ANSI standard DDL commands? It just really honestly blows my mind.. Why don't you guys use them more? I Just love using DDL; maybe it's
|
| Loop through Query Names? | 20 Apr 2008 08:30 GMT | 13 |
I'm trying to code a combo box and want to define a String variable and have a For..Each..Next loop that goes through all the Queries in my database (actually an .adp Access project) and add each query name to the string. Then I can make my Combo's Row Source the string (after ...
|
| Help with a Query Please | 20 Apr 2008 07:05 GMT | 11 |
I want to sort Horse that has Invoicing (true) But if the same Horse has a (False) no sort Horse can appear Many times in this Column so only If they are all (same Horse)True to Sort
|
| Changing default setting in Task | 20 Apr 2008 04:58 GMT | 1 |
I have to enter almost 20 task daily and the default setting for them I need in the Task Category shold be one ( eg LOAD JOB) by default and the recurrence pattern should be by default "Daily" instead of weekly, so that i dont have to select these manually for each of the new ...
|
| Problems with a Query Condition to create Barcode, please Help! | 20 Apr 2008 00:27 GMT | 2 |
I have a query with these columns: "WO" this column shows many Work Order numbers "PlannerCode" this column shows the Plannercodes of the WOs, I have four: ATM-05, BAM-06, JAXM-06 and DGM-05
|
| Error msg: No valid data source could be found for product DAO. | 20 Apr 2008 00:25 GMT | 3 |
Using Access 2003, WinXP. Whenever I initially open Access and attempt to use the Wizard to create a table, query, form etc. in a database, I get the following messages: Please wait while windows configures DAO. This is followed by error msg: Error 1706. No valid data source ...
|
| Calculated field won't work... | 19 Apr 2008 23:55 GMT | 3 |
I created a form from the parent table that only includes the names of sales representatives. I had to create a subform to show their sales for each year. Now I have to create a calculated field to account for a 5% comission rate over their current rate, but I can only use the ...
|
| news letter | 19 Apr 2008 23:49 GMT | 1 |
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252" Debug="true"%> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml">
|
| Issues w/Email Attachments on Free Service email (Hotmail, Yahoo, | 19 Apr 2008 23:44 GMT | 1 |
We have individuals who are attempting to attach Word documents onto their Hotmail account and are unable to. Here’s an example … I open up my Hotmail account and attempt to attach a 1 KB .txt file and I am able to attach and send. For some reason if I try to attach a slightly ...
|
| ghfjh | 19 Apr 2008 21:13 GMT | 1 |
jgfffffffffffffyyyyyyyyyyyyyyyygf
|
| Formula | 19 Apr 2008 21:12 GMT | 5 |
Can any one help me to solve this I have two fields amount and commission. Actual the scenario is like this from 1 to 25000 - the bank will charge 25 as commision and from 25001 to 50000 - 50 then after 50001 to 55000 - 55 and
|
| Duplicate records generated in query | 19 Apr 2008 19:11 GMT | 5 |
I have a query based on another query and a table, when I run the new query it provides the information I asked for, but it duplicates that record. Why is this and can this be overcome. Thanks for anyones help.
|
| ACWZMAIN | 19 Apr 2008 18:47 GMT | 1 |
Can anyone tell me what ACWZMAIN is all about in the Project Folder in VB. Thanks
|
| Parameterized Query | 19 Apr 2008 17:57 GMT | 2 |
For two tables (over simplified for the posting): T1 = **ID, type, detail; T2 = **ID, *T1_ID, value where ** = a primary key and * = foreign key. When I execute the query SELECT T1.type, T1.detail, T2.value FROM T1 LEFT JOIN T2 ON T1.ID = T2.T1_ID WHERE T1.ID = 0 then
|
| Access Relationships | 19 Apr 2008 17:20 GMT | 5 |
I am building a database with the following tables: Techs, Equipment, Workorder Labor, Workorder Parts, Labor Code, and Equipment Returns. I need to sell the equipment to the Techs and they use them on the Workorder. What do I need to do to sell the equipment to the Tech's and ...
|