| Thread | Last Post | Replies |
|
| Access vs Excel Presentation | 23 Jan 2005 15:42 GMT | 3 |
I have to do a lunch and learn type presentation on the differences between spreadsheets and databases. Any suggestions as to where I can find some canned information? Target audience will be a bunch of engineers and scientists that are
|
| I need a function to get the date of the monday in a given (year,weeknumber) | 23 Jan 2005 13:02 GMT | 3 |
I connect to a database that only stores the year and weeknumber. But i need the date of the corresponding monday. This could be more difficult as one expect because the weekumbers might change from country to country.
|
| SendKeys Generates Error | 23 Jan 2005 12:56 GMT | 2 |
I have a macro that uses the SendKeys function to send F9 - to auto save a record. The Application runs perfectly on many PCs, but on one I get the following error.
|
| Access 2000 Tab Control OnChange Event does nothing | 23 Jan 2005 12:47 GMT | 4 |
Please Help. I have a tab control with 4 tabs. When a tab is selected, I want to "do stuff". I thought to just do this:
|
| delete form | 23 Jan 2005 12:30 GMT | 2 |
hi, how can i delete form in for example data_slave.mdb from data_main.mdb (user should click the button in data_main.mdb) Thank you, NiXa
|
| Update Recordset From Code Problem | 23 Jan 2005 10:53 GMT | 2 |
I am missing something here. I have a pop up form (loads from the "main form")that displays multiple command buttons. When a user selects a particular button, the recordset from the main form should be updated. Here is the code that I have written but it doesnt work. I
|
| simple one | 23 Jan 2005 08:54 GMT | 4 |
greetings to all. i am new to the group and to access. I am using access 97 to setup our clinic's database and in one of the tables I need to be able to type in a date only in terms of the Month/Year format? How do I do that? I can't seem to be able to find this either
|
| How to Sum totals contained in queries? | 23 Jan 2005 03:55 GMT | 2 |
I have a number of queries that pull totals from different tables. How do I sum the different total values from each query to get a grand total? I tried using a Union query like this: SELECT cTotal As bct FROM qryCbank1
|
| Efficient temporary tables | 23 Jan 2005 02:25 GMT | 5 |
An application that I develop uses a lot of temporary tables. I very frequently empty the tables (using DELETE From), then fill them back up. Anyone have comments on what effects I might expect to see on performance and bloating by deleting the tables, then using SELECT INTO to ...
|
| How to make ComboBox selection save? | 23 Jan 2005 00:14 GMT | 1 |
I open the "Northwind" sample data base in Access 2003. In the "Orders" form there is a "CustomerID" combobox labeled "Bill To". I scroll thru the list in the combobox and make a selection; that changes the appropriate fields in the displayed record. However, when I close the ...
|
| Re: open an input window by field selection ......- Part II | 22 Jan 2005 23:55 GMT | 1 |
Thanks to those who have provided solutions to previous queries...... I might be making a rod for my own back here but...... I have opened a form when selecting a specific option from a lookup field... and this is where i cant get past ... the field in popup form need to be inputed ...
|
| Changing Backround Color in Access | 22 Jan 2005 22:19 GMT | 6 |
How do you change the backgroung color and Menu bar colors in access so that its different from he default color in windows. This is for Access only, I want the other programs to match the default color of windows. Thanks
|
| Populate text box from selection keeping navigation working | 22 Jan 2005 19:52 GMT | 1 |
Another newbie with a question that I hope someone can point me in the right direction. The goal is to populate a text box with data according to the selection in a combo box while still being able to navigate the records one by one.
|
| ListBox: Changing appearance of selection rectangle depending on focus? | 22 Jan 2005 19:36 GMT | 2 |
Seems like I've been here before, but can't find anyting in Google. I've got two list boxes on a form. Seems to me like the inactive ListBox's selection rectangle should be something like gray...otherwise, the user sees two ListBoxes, both with black selection
|
| Keep together | 22 Jan 2005 18:18 GMT | 2 |
For reporting grades and comments about students, I use one subreport per subject. This includes a number of text boxes, some containing numerical data, but one containing a textual report. Depending on how much is written, sometime there are three on a page, sometimes two etc. ...
|