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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Conditional Moves by Bunky
I have two inputs that I want to join using queries. Normally, no problem but I would like to have a conditional move. ie. I want to move field1 to...
(Multi-page thread 1 2)
August 17th, 2007 02:09 AM
by Bunky Go to last post
14 214
Putting a number from a previous record on a form. by Beetle
As long as the order number is always increasing, then you can use the DMax function to look up the most recent number. Add an unbound text box to your form...
August 17th, 2007 02:09 AM
by Beetle Go to last post
0 80
Can't replace invisible [ '' ] (double apostrophe) strings in fiel by PAGA
While cleaning an Access 2003 database opened in Access 2007, either in Form or in Table view, the Find and Replace function seems to find thousands of...
August 17th, 2007 02:08 AM
by PAGA Go to last post
0 75
"Between" and "And" by scubadiver
You haven't given us much information! If I were to do this in a query it would be either: between #01/01/01# and #01/02/01# or =!! and = !!
August 17th, 2007 02:07 AM
by scubadiver Go to last post
0 95
criteria to see only last four records by wen22222
I have an access question for anyone who can help. Do you know if there is a criteria that can be entered to select the last four records of a patient,...
August 17th, 2007 02:07 AM
by wen22222 Go to last post
5 100
Record find with special characters by Khito
When using the find and replace button, or the findrecord method, Access does not find a match if the value contains the special character # for example:...
August 17th, 2007 02:07 AM
by Maurice Go to last post
1 85
Access to Excel Export - Unresponsive by raymondp
I'm in the process of creating a code to copy and paste values within access and then export the data to an excel worksheet. When I run the program, the...
August 17th, 2007 02:06 AM
by raymondp Go to last post
0 112
Default field size too small by Cat Nichols[_2_]
I'm running a Make Table query using a linked table and one I created. One of the text fields in the table is defaulting to 20 characters and is cutting...
August 17th, 2007 02:05 AM
by Cat Nichols[_2_] Go to last post
0 58
Removing data from table by mbing916
I am a new access user. I have two tables, the master and the other table. What is the best way to remove all the records in the other table from the...
August 17th, 2007 02:05 AM
by mbing916 Go to last post
0 57
Default to No Primary Key on import by Peter Gr
Hi gang, On importing files into Access, is there a way to set the default in the Import Wizard to "No primary key" instead of the "Let Access add primary...
August 17th, 2007 02:05 AM
by Wayne-I-M Go to last post
4 99
How do I change the way conflict winners are picked in Access? by Jerry Whittle
I'm assuming that you are not using the built-in replication tool. In your shoes, I'd use replication as it would better automate the synchronization...
August 17th, 2007 02:05 AM
by ELA3355 Go to last post
2 65
Please help! Interface Design by willm16
I need to create an interface in Access 2007 for a non profit organization. Just to give you a little background information, this organization gives money...
August 17th, 2007 02:01 AM
by willm16 Go to last post
2 63
Old Access Table and Checkboxes by KARL DEWEY
Yes, in your form add a check box and set source to that field. -- KARL DEWEY Build a little - Test a little "Erika" wrote: I have an old Access Table...
August 17th, 2007 01:59 AM
by KARL DEWEY Go to last post
0 61
Multiple parameters in a union query by KARL DEWEY
WHERE Like "*" & & "*" AND Like "*" & & "*" -- KARL DEWEY Build a little - Test a little "Karen" wrote:
August 17th, 2007 01:57 AM
by KARL DEWEY Go to last post
1 63
Removing data from table by SteveM
First, do a backup! If you edit the relationship between your master and child table(s) and check the box for Cascade Delete Related Records, when you delete...
August 17th, 2007 01:56 AM
by SteveM Go to last post
0 95
Access file will not open... Need some Creative Ideas by Dadeo
I have a client who has been using a custom built Access DB for years... a few days ago he calls me to say his Db wont open and it gives a message... Maybe...
August 17th, 2007 01:54 AM
by Jaybird[_2_] Go to last post
2 172
autofilter table headers in access by dandowftm
In Access 2007 i have noticed that the the table headers have a new feature where a drop down menu can be seleted allowing a custom filter to be set where...
August 17th, 2007 01:54 AM
by dandowftm Go to last post
0 67
Get User by Muriukis
Thanks Daniels for your answer but am yet to be satisfied.The form login is unbound and it has two textboxes UserName and Password.What I have done is set...
August 17th, 2007 01:54 AM
by Ken Sheridan Go to last post
1 115
Multiple parameters in a union query by KARL DEWEY
The prompts are the exact wording you put inside the brackets. -- KARL DEWEY Build a little - Test a little "Karen" wrote: Thanks Karl. However, the...
August 17th, 2007 01:53 AM
by KARL DEWEY Go to last post
0 86
Find and replace unique records by Ken Sheridan
You can use the IN operator with a value list to return rows where a value in a column matches any one of the values in the list, e.g. UPDATE YourTable SET...
August 17th, 2007 01:53 AM
by Ken Sheridan Go to last post
0 52
Post New Thread


Display Options
Showing threads 40001 to 40020 of 92186
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:01 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.