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 : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Change size of pop-up for parameter query by Rose
Is it possible to change the size of the pop-up that appears when you run a parameter query? I'd like to make the message longer than the allotted 37...
May 24th, 2004 06:24 PM
by Lynn Trapp Go to last post
1 355
Object Names contains tidle (~) by Roddy
hi, Can anyone provide any information about the purpose or use of the tidle character (~) in object names, such as queries? Thanks, Roddy
May 24th, 2004 07:12 PM
by Roddy Go to last post
2 306
Access Modules by Tausif Alam
Hi Guru, I need your help again. I like to call a access Module in access query. But it gives me error. Module: ----------- Function GetDatePart(pDate As...
May 24th, 2004 08:22 PM
by John Spencer (MVP) Go to last post
1 263
Query two fields into one combo box by JohnLute
tblCGStyles has two fields: txtCodeID (key) txtCorrugatedStyles cbStyle in my form queries both of these fields. How do I get the two fields to display in...
May 24th, 2004 08:57 PM
by Wayne Morgan Go to last post
2 553
changing date format in a query by Elisa
How do I change a date yyyymm to mm/dd/yyyy?
May 24th, 2004 10:01 PM
by John Vinson Go to last post
4 332
Urgently need help with a database file!!!!!! by Shane
Good day. I really need some help! Someone here at our offices deleted a Access database file. I retrieved the file, but now it doesn't want to open!!!!!! It...
May 25th, 2004 03:30 AM
by Gary B Go to last post
2 479
Dynamic Field Name in Query By Date by John Vinson
On Fri, 21 May 2004 02:09:55 -0500, Sakuraki wrote: Any...
May 25th, 2004 03:39 AM
by Duane Hookom Go to last post
2 584
Help to create databse by GabrielG
Hello everyone , I have a little issue to setup a database. I created a table with approximately 20 columns. The columns have an entry of Yes or no base on...
May 25th, 2004 05:29 AM
by Duane Hookom Go to last post
1 319
Make Table Query takes long time by
I'm using a make table query to create a new table from Paradox tables. There are about 80,000 records in the Paradox tables and the process takes about 30...
May 25th, 2004 06:06 AM
by John Vinson Go to last post
1 662
How to update a field with value from 2 calculated fields (dates)? by Chris1
Hi I really need some help on this one: I have one table containing tools to be maintained: There is a . The third field is the one that needs to calculate...
May 25th, 2004 09:45 AM
by Chris1 Go to last post
3 406
Month query / View by sotiris_s
I have a table that have a field that holds dates and i have name it as "Mera" , now i want to make a query to show me the products from that table in a...
May 25th, 2004 10:47 AM
by Nikos Yannacopoulos Go to last post
1 561
Requery Combobox by MJ
I have a combobox with an event that adds a record if the 'id' doesn't exist. I try to requery the control (combobox) but I get an error 2118 saying I must...
May 25th, 2004 11:01 AM
by Gary Walter Go to last post
7 1,097
several report fields from one table field by Steve
I have two fields which is a contact number and which is Cell, Home... I have a report where I want to list each person's home number and cell number but I...
May 25th, 2004 11:49 AM
by Go to last post
2 442
Reserved error (-3011) by BobRoyAce
I inherited a database and need to make some changes to some queries. The table and field names are crazy (include spaces, etc.), but I have nothing to do with...
May 25th, 2004 12:05 PM
by Gary Walter Go to last post
1 491
Month number output instead of month text by Miquel Korah
Yes the month is a result of a crosstab query. In fact its a row heading with an alias - Month: Month(). I have right clicked on the column in the crosstab...
May 25th, 2004 12:17 PM
by Gary Walter Go to last post
1 585
Creating a stored procedure (query) in access by Michel Walsh
Hi, CurrentProject.Connection.Execute "DROP PROCEDURE toto" will drop the procedure (not procedute, as in my first message, sorry for the typo).
May 25th, 2004 12:29 PM
by Michel Walsh Go to last post
0 790
DSum - cumulative calculation by Birger
I tried the previous code, it produced an error. Looking at it, I think would calculate the sum of the yield. I need the cumulative percent yield. I have...
May 25th, 2004 12:43 PM
by Michel Walsh Go to last post
1 573
Find Records that ovelap by John H
I have a table with 2 date fields startdate and enddate. They vaules are long int in yyyymmdd format. I want to check for any overlap between records. Eg if...
May 25th, 2004 12:51 PM
by Gary Walter Go to last post
1 320
From one table -> update the fields from other table by Samora
Hello I have a form who have 10 fields from TABLE1 that after make calculations with them i build the field M1 from TABLE2 The event that fires those...
May 25th, 2004 12:51 PM
by Michel Walsh Go to last post
1 579
calculate time by clanmccreery
Hello My time clock database uses "short time" format for calculating total hours worked, etc. The problem I have is that there is a field called which is a...
May 25th, 2004 01:00 PM
by Michel Walsh Go to last post
1 471
Post New Thread


Display Options
Showing threads 21 to 40 of 43289
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 05:45 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.