Order By Property Not Working

Oct 27, 2006

i have two forms - frmOne and frmTwo. frmOne opens frmTwo with this code:
intVar = Me!l_id
intRoom = Me!l_room
stDocName = "l_surveys"
stLinkCriteria = "[l_id]=" & "'" & intVar & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
on frmTwo i have the property for Order By set to "frmTwo.l_date DESC" but it never orders it by the date DESC....i've even tried to set it using VBA and i can't get it to work properly...

suggestions?

View Replies


ADVERTISEMENT

What Does The 'Order By' Property Of A Form Do?

Oct 28, 2005

Hello,

I've sorted out a problem that I had with a Form that had a subtable on it, by setting on the properties of the form for the 'Order by' criteria to equal the Id number of the form. eg: if each record has an Idnumber I have put [Idnumber] as the Order by property.

I have no idea what this does though, even though it seems intuitive? it's a form... so what is there to order? hope i'm not just being very stupid!

Thanks

Peter.

View 3 Replies View Related

Updating Label Visible Property Not Working

Dec 7, 2006

i am running a query that takes few seconds to run but during that time i want my label to say "please wait'' so when the form loads i have it as:

lblstatus.visible=false

and when the user click on generate report that runs teh query i have as:

button_click starts
lblStatus.visible=true
button_click ends

but guess what, this doesnt work!! looks like the screen is not updated until the button_click processes, if i add a msgbox() after lblstatus.visible=true it shows but after the msgbox which i dont want. anyone know why?

View 1 Replies View Related

General :: Add Existing Fields And Property Sheet - Buttons Not Working

Sep 1, 2014

I have a problem with two buttons, add existing fields and property sheet

When i click them they do nothing at all, so i cannot do what i need to do?

View 9 Replies View Related

Tab Order Not Working

Aug 28, 2007

Hi everyone,

On a form, I want to fix the tab order of the text boxes. So I go to the tab order property of the form and when it opens, it doesn't let me change the order. Can anyone help me on this?

Thank you very much

View 7 Replies View Related

ORDER BY (alias) Not Working...

Nov 26, 2003

rsQuery.Open "SELECT colorDepth, COUNT(*) AS colorDepthCount FROM px_users GROUP BY colorDepth ORDER BY colorDepthCount, colorDepth", dcnDB, 1, 3

returns the following error:

No value given for one or more required parameters.

Is this just an Access thing, where it won't order by an alias?

View 5 Replies View Related

Working With Different Order Services?

Jun 18, 2014

I have :

tblClient : Name, address
tblAgent: Name, address..
tblInsuranceCompanies: Name, Address.
&

Lets say :

tblCarOrders: OrderID, TransactionDate, ClientID, AgentID, CarMark, CarModel, PlateNumber, PaymentID,
tblOrderDetails: CarOrderID, CarPolicy, PolicyCodeNumber, ActiveDate, expiryDate
tblCarPolicy: CarPolicyID, PolicyDescrpt., InsuranceCompanyID, NetPremium

& also have : tbl Payment or methodPayment ..

If I have also HEALTH and EXPAT (servant) Policies that their details structure are completly different in Order and OrderDetails tables .

ex: tbl HealthOrder: OrderID, TransactionDate, ClientID, AgentID + DoB, and tblHealthPolicy: In, Out , etc And same is for Expat that is different also of Health and Cars Policy and Order..

How to make all the three ORDERS ( car , health and expat) working on one OrderId to make it easly for me when I am working on PAYMENT .Note that I am working on THREE different Order Forms here . and only Payment Table is the common in each Form..

View 2 Replies View Related

Allow More Than Order In ORDER Form

Apr 4, 2013

I have a problem when I want to create an "ORDER" form, that will allow user to enter more than one order.

I have no clue how to do it.

View 14 Replies View Related

Program Working In Access 2007 Not Working In Access 2010 Due To Missing OCX File

Dec 27, 2014

I have a program that runs under access 2007 that I use at my work. We will soon be updating to MS office 2010 and the program will not work now because a calender file .ocx was removed from access 2010. Is there a way to get the 2007 .ocx file to work in access 2010?The program I am using is a relatively simple stand-alone and unsupported app that we use to request patient arrival and departure from various radiology tests inside a hospital. No reports are made from the app other than the number of patient transports for the day.

The app is placed on a common drive accessed from any pc in the hospital. No special permissions are required. But our app does use the calendar, time and date functions in access 2007. When I tried the app on a pc with access 2010, it basically says it (access) cannot open the app because a .ocx file is not present.Is there a way to make the access 2010 calendar file work in access 2007?

View 1 Replies View Related

Duplicate Record Command Button Not Working For One Form But Is Working For Other Form

Jan 15, 2015

I have an Access 2010 database with two tables and two forms. The tables are Organizations and People. Similarly, the forms are Organizations Entry Form and PeopleEntryForm. The People are linked to the Organizations table. Several people can be linked to the same organization.On my Organizations EntryForm, I created a command button to duplicate a record using the wizard. It works fine.

I did exactly the same thing on the PeopleEntryForm, but instead of copying the record, it creates a new blank record. I don't get any error messages. Is my problem due to the fact that the People table is linked to the Organizations table?

View 13 Replies View Related

Always On Top Property

Jul 14, 2007

I have a problem. The problem is that I have a form contains two list boxes controls and a calender control. The calender control is invisible by default.
When I click a Show button, to show the calender contol, it appears but behind the list boxes controls. How can I allow it to fully appear on top of all the controls in the form.

Thanks,

View 2 Replies View Related

Tag Property

Jun 26, 2005

I have never used the tag property but while reviewing some design stuff it occurred to me that maybe I am overlooking it's usefulness and was wondering how some of you may have used it...?

View 8 Replies View Related

Calendar Property

Jun 6, 2005

Please pardon my ignorance, but how do I set up a ActiveX calendar in Access? The help files are missing from the version of Access 2000 I am using, and I really don't know what I am doing. I would be grateful for any help with this.

Thanks.

View 3 Replies View Related

BackColor Property

May 8, 2007

hello,

I have a txtBox. Its backColor property changes according to what I do on the form. Now, when I close the form and reopen it, the backColor is not the same one with which the form was closed.

Ex. red, green
if I close the form having the backColor = green, then when I reopen it, it changes to red.

Can anyone tell me what I am missing

Thank you

View 4 Replies View Related

Using Column Property In SQL

Oct 23, 2007

Hi all

I have searched through this forum and on google, and I know that I can refer to a combobox's column property IN VBA by

[myform]![mycombobox].column(1)

When I do this in SQL, it complains that there is an "unidentified function" (column). What am I doing wrong?

View 3 Replies View Related

How To Set The Required Property Via SQL

Aug 1, 2005

How do I set the Required property for field that already exists via SQL. I'm thinking along the lines of: ALTER TABLE table1 ALTER COLUMN field1 text(50) NOT REQUIRED.

But this doesn't work, any clues?

View 5 Replies View Related

Property Value Too Large

Jul 17, 2007

I'd like to create a table with 240 fields. I know that the max is 255, however, I'm getting a message "property value too large" after I've created 114. Any ideas? All the number fields are byte size. Thanks!

View 10 Replies View Related

Where DropDownList Property?

Aug 12, 2005

I build a form with Combo Boxes, and can not find "DropDownList property".
Can anybody help me.

Thanks

View 2 Replies View Related

Property Value Is Too Large

Nov 14, 2005

I guess I have too many columns in my database and I'm getting the error message "Property value is too large" when trying to open the database table. When I was using Access 2000, I was still able to open the database but using Access 2003, the database will not open. Is there a way around this so I can open the table to fix it?

View 14 Replies View Related

OnLoad Property

Mar 3, 2006

What I'd like to do is for my combo boxes to say something like "Select One" when the form is first loaded, until the user opens the box and selects something. My combo boxes work fine now, but they are currently empty when the form loads.

From my google research it appeared that the OnLoad property would probably help me do what I want, but I can't seem to find this property anywhere in Access. It's not anywhere in the property window and the help search doesn't return any results.

I'm using Access 2003 from MS Office Professional Edition 2003.

Am I missing an upgrade or does my version not have this property, or am I just missing it?

View 2 Replies View Related

Selected Property

Jan 12, 2005

Hi all

I have a lstbox on a bound form. the lstbox is based on a query. I want the first item in the box to be selected. This is what ive used:

Private Sub roll_class_select_AfterUpdate()
DoCmd.Requery "lststudents"
Me.lststudents.Selected(0) = True
End Sub

But then the form gets stuck. None of the other controls will work. The first list item is selected but it then wants to be the centre of attention and everything else can bugger off.

Any ideas as to how I can fix it??

Damon

View 6 Replies View Related

.AbsolutePage Property

Oct 21, 2005

When I attempt to run my results page with paging I get the following error:

ADODB.Recordset error '800a0cb3'
Object or provider is not capable of performing requested operation.
/slug/revslug/Administrators/AdminReports/Timesheet/TechnicianAllocation.asp, line 185

I have included a few key lines of code:
Code:strDBPath = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.Mappath("/slug/RevSLUG/DB/TimesheetDB.mdb") & ";"if strTechName = "All" Then strSQL = "Select " & cstr(strReportType) & ", SUM(Hours) as SumOfHours FROM Results WHERE (PerDate >= #" & cdate(strStartDate) & "# and PerDate <= #" & cdate(strEndDate) & "#) GROUP BY " & cstr(strReportType) &";"ElsestrSQL = "Select " & cstr(strReportType) & ", SUM(Hours) as SumOfHours FROM Results WHERE (PerDate >= #" & cdate(strStartDate) & "# and PerDate <= #" & cdate(strEndDate) & "# and TechName = '" & cstr(strtechname) & "') GROUP BY " & cstr(strReportType) &";"End IfSet rstSearch = Server.CreateObject("ADODB.Recordset")rstSearch.PageSize = PAGE_SIZErstSearch.CacheSize = PAGE_SIZE' Open our recordsetrstSearch.Open strSQL,strdbpathiRecordCount = rstSearch.RecordCountiPageCount = rstSearch.PageCount' Move to the page we need to show.rstSearch.AbsolutePage = iPageCurrent'this is line that contains the error(line 185)

How can I fix this problem...I think it has to do with the settings when I open the DB but I don't know what the settings should be to make it work correctly.

Thanks
Mark

View 4 Replies View Related

Which Event Property?

Dec 12, 2006

I have a subform (subform1) which allows me to select a value which then dictates which record is shown in the other subform (subform2). I want to run a macro every time subform2 has a different value -- without me having to click anywhere in subform2. I have tried to attach the macro to every place I can think of and it just doesn't seem to run. I am thinking it is because subform2 isn't receiving the focus. How do I give subform2 the focus and which event property should I be trying for?

View 1 Replies View Related

Form Property

Aug 27, 2007

Is there a way to change the background color of an field that has enable = off from the default "gray"? I can set it to transparent but I can't change the font color to see the data clearly.

Just trying to make the form "nice looking" to the user.

Thanks
Jeff

View 1 Replies View Related

Forms :: How To Use Tag Property

Dec 15, 2014

I have seen someone's database that had tiny circles containing a "?" which, when clicked, opened up a sentence or two. A search for "Tag" on this site strikes out, also.I am hoping to place these little links near fields that may need more explanation. In the ones I have seen before, the little explanation field that popped up disappeared as soon as the focus went elsewhere without the user having to close it. I have succeeded in using the tag property to open a true popup form, but this is clunkier than I want--would just like to learn how to do the other.

View 4 Replies View Related

Intellectual Property Rights

May 12, 2005

I have designed a software package based around an Access Database at my company (based in the UK). There is a good chance that the company will be able to sell the software and potentially make a handsome profit.

My boss wants me to sign an Intellectual Property Rights agreement. Does anybody know what this means? Which of my rights does it effect? Would it prevent me from developing the same software if I left the company?

Any help would be much appreciated. I've found some resources on the web but they seem to apply mainly to music. Just wondered if anyone had had a similar experience.

Cheers.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved