Below is a script that I want to present in descending order but it is coming up with the error:
Microsoft VBScript runtime error '800a000d'
Type mismatch
/tribute2.asp, line 175
Could it be that the remid and gbid are in two different tables in the database .... or have I just got the scripting all screwie ... the line where the error is occuring is the first set of code ... the second set of code is the area that it relates to ...
I want to sort my query results by VendorNumber (which is an AutoNumber won't be sequential due to deletions). I want to sort the query by what vendor number the current form is on. So if my vendor numbers are 1, 2, 14, 16, 17 and the vendor number on the form is 14, I want the query to be sorted with the Items from vendor 14 first then 16, 17, 1, 2.
Your time is appreciated,
JOe K.
I have a report that generates the position of certain items. When I produce this report it doesn't put the data in order. All associated data with that position is correct, it is just not in numerical order. The attached screenshot shows the issue I am having. In the position column it should read 1,2,3,4 but in some cases the positions are not in order.
View 2 Replies View RelatedI am on code want to display records on the form by order_number, but i am unable to do it.
Private Sub Combo63_AfterUpdate()
Dim rs As DAO.Recordset
Dim intcount As Integer
On Error GoTo ErrorHandler
Set rs = CurrentDb.OpenRecordset("SELECT * FROM Master_Log WHERE Order_number = " & Combo63.Value & "", dbOpenSnapshot)
[Code] ....
Hi All,
I have a field named "PICK_DATE" in text format where pickup date is stored in DD/MM/YYYY format.
Now I wanted to generate a report with the order by clause of PICK_DATE. But it is not giving me the desired result. I want to see the latest PICK_DATE at the top of the report in desending order.
Can any one pls help me out to solve this problem ? :confused:
Thanks in advance,
Jignesh
Hi
I am looking for an equivalent for the DESC command in Access.
I need to extract the table definitions: name of each fields (at least).
I know I can print that from the menu in Access, but it's not what I want. (and it does not print the comments section of the fields)
I need to be able to generate some kind of text file cause I need to manipulate the output myself with a Text Editor for documentation purpose.
Is there such a function in Access? Or is there any module that can do that?
Thanks
I have a query that lists items in locations in our warehouse. Each location is broken down by Aisle-Bay-Level-Position, for example 50-101-01B; or 51-106-02 with all the even Bays on one side and Odd bays on the other side of the aisle. I have the query set up so it separates odd and even so I can go all the way down one side of the aisle then I have to walk back to the beginning of the aisle to check the other side.
What I am trying to do is change the sort based on another field that I have called SORT with a value of AZ or ZA depending on if I need that section to be sorted ASC or DESC. So for example all even bays in aisle 51 need to be sorted DESC while all ODD bays would be ASC. The way our warehouse is laid out it is not always the odd or even side that needs to be sorted DESC, that's why I made the SORT field. The formula I used for the SORT field is as follows:
SORT: IIf(([Aisle]='50' And [OE]='ODD') Or ([Aisle]='51' And [OE]='ODD') Or ([Aisle]='53' And [OE]='ODD') Or ([Aisle]='52' And [OE]='EVEN'),'AZ','ZA')
Is there a way to make it sort the BAY in ASC or DESC based on the value in SORT?
As an example here is how I want the order to be:
50-101-01A
50-101-01B
50-103-02A
50-103-02B
51-101-01
[Code] .....
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.
Hello!
I have been struggling with this problem for a while and I'm so deep into it I can't look at it clearly anymore. I hope someone can give me some advice.
I'm trying to set up an orders database, but instead of one "product" I have a service with many specifications. One service part can have many kinds of inspections, which in turn have many inspection criteria.
That part seems okay to me, I guess. There's a one to many relationship between services and inspections, and a one to many between inspections and criteria. The problem is displaying that in a form in a way that's not confusing to the users - I can't put all that info in one line, and I can't put subforms in continuous forms, the best I can come up with is to have separate subforms that display the inspection types when the part number is selected and the inspection criteria when the types are selected. The users I tested it on are totally confused about it. What's the best way to go about displaying it?
I secretly just want it to look like this!
PartNumber Service Criteria Price
1001 Gauging (for) Length $100000!
(for) Diameter
Sorting (for) Rust
2222 Sorting (for) Rust $10
Maybe that's just as confusing. A fresh perspective would help.
This forum has been such a wonderful resource to me and I've learned a lot. I feel kind of embarrassed posting because I know my questions are access-ignorant, but I'm really having trouble figuring this one out on my own. Thanks for any ideas.
I am having a proble displaying a .pdf file on a command button action.
Here is the part of my code that calls up the file:
Dim StrProg As String
Dim StrFile As String
StrProg = "C:Program FilesAdobeAcrobat 7.0Reader.exe"
StrFile = "C:Program FilesPolaris Medical Chart Ver3.3example.pdf"
Shell StrProg & StrFile, vbNormalFocus
Exit Sub
I get a file not found error. Any thoughts??
Thanks
This is probably simple but it's something I haven't had to do before.
I have a main table.
I have a filter query based on this table.
I have a report, based on the query, which displays the total number of records in the query.
In the same report, I would like to display this total as a number (already done, obviously) and also as a percentage of the total number of records in the main table.
How would I go about this?
Can't figure this one out. I am trying to get my query to show me which company's have not sent a supplier any money during a certain period.
However if I have the following data
abc company
1/10/02 £5
1/12/02 £10
an i search for any company who has not sent any money between 2/10/2 and 1/11/02 abc company does not show up because there is no data between these dates. If I had a record 2/11/02 £0 it shows up. So what criteria or query can I use to show this up?
many thanks
Hi,
I'm using Access 2000.
After a very very very long time i've manged to crack my first QBF! When I click the command button to run the macro and display the results, the results are coming up in a table format.
Is there any way to have the results of the QBF displayed on the same form?
For example, if I have a table that contains my different products and their categories - in this example 50 different types of "toy trucks", 75 "toy cars" and 100 "toy trains" - and I then perform a QBF on the criteria of product type, in this example "toy cars" - I would want the first "toy car" record to show on the form in their relevant fields, and be able to scroll through 74 records before coming to an end.
This way I could easily place all my products in one table, then select which products I'd like to view in the form and scroll through them.
Any help would be greatfully appreciated as I haven't been able to find anything online.
Thank you in advance.
Hi, sorry if this has been covered before, I am a new guy around here.
I have two tables in a select query, both with a code field and a monetary value field. The codes are linked. This query is to show the variances in the values of each table as they are meant to have identical codes and values. However, each table has a small handful of codes that are not in the other, but all the query outputs is the variances for codes that are in "both" tables. I realise you can do one way relationships so that you can display all from one table and only those matching from another. However I need the query to show "all" the codes from both tables, and the value difference.
Any advice on going about this? Would be much appreciated! Thanks. :)
My query tallys the no of reject by plant and displays in a report, and this works great, but now it's a new year, only 3 plants have rejects (which is really a good thing), I need a 0 to display for the other 2 plants but don't know if this can be done, any ideas?
Plant (5 possible) group by;
Expression: Counts # of Rejects
by DateReceived 1/1/08 to 12/31/08
I have 500 Records in my Software Table, and I would like to display only those records that match my criteria that I place in my text box on my form called Software Name. So Once I have entered the software type in my text box, then I would like to display those records at the bottom of the screen as the selected records.... Any ideas??My table is called, Software, which contains Software Type, Software Name, Serial Id, Comments, Inventory Number, Version , Key and Company... I have a text box that is called txtSoftware, Which searches the databse and display the information in a list box called, lstResult, I would like to however, have the option, display in the list box but also display those records on the bottom of my form as it will look like in design view of my table. I have no idea how to ever start the idea ....
View 1 Replies View RelatedHi,
First of all thanks to everyone who has answered my questions already, although I'm still having problems (more with my understanding and lack of Knowledge)
I'm creating a DB and I'm stuck, I'm trying to create a form that has three fields mailbox, applications & Drives. Each of these three fields need to be populated with many items. For example the mailbox field may have 5 different mailboxes required to be populated in this field.
What I want to happen is for the user to double click on the text box, then a new form containing a multi-select list box appears that you can select the items you need which in turn updates the role profile form. This is how I want it to work but if you have a better idea I'm all ears.
All I want is for someone to be able to view the role profile form and to be able to see what applications, drives and mailboxes are required for that role.
Basically I have no idea how you can get someone to choose several items and have that reflected and recorded in the required record.
I have attached what I have at the moment and any help or advice you can supply is appreciated.
I have set up a bound object frame on a form, everything works good, only problem i have is the picture doesn't display but the name of the picture does, ie...picture.jpg. if i click on this the picture is displayed in microsoft office picture manager, I think I'm close..maybe just a shove away..
Please help if you can,,
Thanks,
Jerry
Hi -
Trying to display PDF in a form. Ideally, I would like to link one or more PDF's to each record in a table and be able to view the PDF within the form. Opening the file via double-click would be a nice bonus.
I've looked at a helpful post here
http://www.access-programmers.co.uk/forums/showthread.php?t=100877
which describes doing this through ActiveX
Part of my trouble is I don't understand the ActiveX well enough. I was able to make this work with a sample file, but then I lost all the tool bars that were on the document and can't get them back. I also can't figure out how to get the double-click to open to work. Is there documentation somewhere on the ActiveX control?
I also tried using an OLE object. I can create a form in design view that contains a linked PDF, but I can't figure out how to index off a table. I also can't figure out how to resize (for a thumbnail, for example).
Thanks for any assistance,
- gromit
Hi guys
I have a problem. In form view, if you use the mouse wheel to scroll down, you switch to the next record. Is there a way I can disable this? Even if I switch the RecordSelectors and NavigationButtons properties in the Form Selector to "No", it still goes to the next record as soon as you scroll down with the mouse wheel. I want the Form to scroll down if you use the mouse wheel, not go to the next record as it does now.
Please help. I don't know what to do. Thank you in advance.
kruger101
Hi I would like to know if it is possible to display the & sign. I need to beable to use this both in form titles and on command buttons. When ik type it in as a caption it is displayed but as soon as I come out of edit mode I am left with a _ in place of the &
any help would be great. Thanks Paul Evans
I have the following code on the field date on a subform:
Private Sub TripDate_DblClick(Cancel As Integer)
On Error GoTo Err_DblClick_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Trip NV"
stLinkCriteria = "[TripDate]=" & "#" & Me![TripDate] & "#"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_DblClick_Click:
Exit Sub
Err_DblClick_Click:
MsgBox Err.Description
Resume Exit_DblClick_Click
End Sub
When I doubleclick on certain records on the subform it will open the form TRIP NV diplaying me the linked record, on other records it will open the form TRIP NV but a blank form with no records displayed!
Why is this happening?
Marco
This is probably a very basic question, but I'm going to ask it anyway.
I have two tables linked together, in a one to many relationship (a supervisor table, and an employee table). Each supervisor can have many employees that report to them. I then set up a forum to enter new employees as they come into the corporation, and need to referance which supervisor they report to, I have a drop down box that I want to display SupervisorLastName, SupervisorFirstName (for example, Williams, George) but is only displaying the SupervisorID (for example 60).
How can I make the forum display Williams, George instead of 60?
Thanks in advance for your help.
Hello All,
I recently added a couple cascading combo boxes to one of my forms and now the data from the underlying table that has already been entered does not show up unless I go in and reselect the options.
Anyone have any ideas on how to fix this?
Thanks,
In a Query, how can I display in one column a value that can come from 2 different fields based on a selection.
Say I have two date fields (Date1 & Date2) they can both be blank, or one or both of them could have a real value. To make it simple here is the logic I want to employ.
If Date2 > " " display Date2, otherwise display Date1. I want the value to appear in the same column. Can this be done in a query or must it be done in a report?
Thanks!
Hi,
I am creating an access DB that has job listings
and displays the DB online.
I am creating tables rows for 'BeginListing' and 'Endlisitng'
etc that are stored as a Date
How do I get the asp/vbscript to check the date 'EndListing'
of the entry and to stop displaying it when the date is
later than today (so it takes them offline when the date is
expired)?
My script is like this and loops through each record set displaying the
contents:
'Loop through the recordset
Do While not rsJobPostings.EOF
'Write the HTML to display the current record in the recordset
Response.Write ("<div class='sitetext'><br> Job Number: ")
Response.Write (rsJobPostings("Job_Number"))
Response.Write ("<br>Job Heading: <b>")
Response.Write (rsJobPostings("Job_Heading"))
Response.Write ("<br>")
Response.Write (rsJobPostings("ListingEnds")) .... you get the idea.
Cheers thanks.