A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Calculating Text to Numbers by Darlene
Thank you in advance for any help that you can offer... I would like to be able to add up all the “Theatre” entries and convert them to a number - ex....
August 25th, 2009 10:00 PM
by Darlene Go to last post
2 162
DSum with multiple criteria by GD
What's wrong with this DSum (I'm getting the #Error message): DSum("","T06_REC","=" & ! & " And ='Mueller'") I need to return the (number format) from the...
August 25th, 2009 09:33 PM
by John W. Vinson Go to last post
1 159
DLookup (Or ELookup)? by Deb
I'm designing an Inventory Program. I have an Inventory Table (tbl_InventoryListing). The Program is driven by Part Numbers. I have a lookup table...
August 25th, 2009 12:52 PM
by Deb Go to last post
5 250
Error going from first field to last field in previous record by Jason[_38_]
The following codes works except for when I use shift tab to go from the first field to the last field in the previous record. The error is: Run-time error...
August 25th, 2009 09:38 AM
by Jason[_38_] Go to last post
2 162
Combo Box Error by Kathy
I have created a form using the form wizzard, which added all of the data I needed to my form. However, one of the items on my form is Employee Last Name. ...
August 25th, 2009 04:04 AM
by John W. Vinson Go to last post
2 185
Combo Box text display question by Lostguy
Hello. I have a combo box on the form. On the properties for that box, I select the query using fields employeeIDpk, FName, LName. The bound column is 1 and...
August 25th, 2009 04:03 AM
by John W. Vinson Go to last post
5 172
Combo Box text display question by Lostguy
Hello. I have a combo box on the form. On the properties for that box, I select the query using fields employeeIDpk, FName, LName. The bound column is 1 and...
August 24th, 2009 11:12 PM
by Lostguy Go to last post
0 174
Replace values with a foreign key. by Gluefoot
Hi everyone, fairly new to Access. I have a table "TRACKING" with a column that has USER_NAMES. There are about 3000 records in this table. I'd like to...
August 24th, 2009 05:31 AM
by John W. Vinson Go to last post
1 164
Date filter by Arvin Meyer [MVP][_2_]
Sorry, that was wrong, it will prompt a second time. Instead use: Select * from tblSchedule Where DateField Between Forms!Schedule! And Forms!Schedule!; and...
August 23rd, 2009 07:03 PM
by Arvin Meyer [MVP][_2_] Go to last post
0 179
cannot use nz function by Jason[_38_]
I have a query (running the query under queries) that works fine with where nz(amount)0 however when I use currentdb.execute "Update amount=0 where...
August 23rd, 2009 12:05 AM
by Jason[_38_] Go to last post
5 237
32123 by sue
32123
August 22nd, 2009 04:22 PM
by sue Go to last post
0 149
ACCESS 2007 DATABASE SIZE by Jim[_49_]
Is there a database size limit for Access 2007 or is it determined by storage space?
August 22nd, 2009 03:42 PM
by Arvin Meyer [MVP][_2_] Go to last post
5 232
Database Template by Kris D
Hopeing I can get some help, actually I need a lot of help. I work at a college for a small student service program. We only use spreadsheets to store data....
August 22nd, 2009 12:26 PM
by Philip Herlihy Go to last post
1 120
Net book and Microsoft Access by Prashant Shah
Res.All, Recently many companies have introduced Netbooks. Has anybody exeperience of programming in Microsoft Access in this device? Is it slow? Thanks...
August 22nd, 2009 06:54 AM
by Arvin Meyer [MVP][_2_] Go to last post
3 311
Maximize/Minimize by Ron
I use my form in MAX mode. On my form I have a button to a little timer. When I open my timer, it opens in MAX mode also! I want it to open so that it is in...
August 21st, 2009 10:46 PM
by Ron Go to last post
0 109
null or y=yes by Rosie1956
I need a field to be null or yes, and would like not to have to type in yes but just the letter y. I never use access except for one document which never...
August 21st, 2009 05:05 PM
by Jerry Whittle Go to last post
1 141
Format Date and Strconv by Roger Bell
I have a field in a report as follows: =Trim("ON THE" & " " & Format(,"dd mmm yyyy")) returns "ON THE 25 May 2009. This works fine, however I would like the...
August 21st, 2009 02:30 PM
by John Spencer Go to last post
3 145
Can we export to a text file to the desktop but using relative paths? [A03] by StargateFan[_2_]
Exporting data is pretty standard, I imagine but can A03 be set to save to a desktop via a relative path so that the file works no matter what computer we're...
August 21st, 2009 12:59 PM
by Douglas J. Steele[_3_] Go to last post
7 236
I want to add different cell in One Cell by Atif
Actually, i have the situation that i did total of some amounts in a cell. And then many more totals like this about 85 totals. Now i want to get Grand Total...
August 21st, 2009 10:53 AM
by Philip Herlihy Go to last post
1 144
I want to add different cell in One Cell by Atif
Actually, i have the situation that i did total of some amounts in a cell. And then many more total like this. Now i want to get Grand Total of all these...
August 21st, 2009 07:28 AM
by Atif Go to last post
0 163
Post New Thread


Display Options
Showing threads 1021 to 1040 of 17167
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.