Best Method To Display Data.

Jan 28, 2007

Hello. I am quite new to Access and even newer to this forum. So please be gentle...

My question is quite simple i think. I want to display one particular record.

I have a keyboard wedge barcode scanner.. so basically a quicker and easier way to input digits or letters into a field. I also have lots and lots of CD's DVD's which i want to track and list the contents of, by simply entering the cd/dvd's barcode number istead of having to insert into my pc and browse manually.. if possible searching within results would be good too.~
think of it as a supermarket style.. input number - output entire contents... there could be hundreds or even thousands of programs or music titles,images, videos or documents.. along with any associated data, (where it is stored, who borrowed it last etc)

Can anbody outline the basics for me to implement this? remember i am quite new to Access and databases in general.

Thanks in advance, and keep up the good work on/in this forum. :)

Rob

View Replies


ADVERTISEMENT

Best Method Of Storing This Data?

Jun 7, 2005

Hi everyone,

I've recently begun building a database to keep track of stock at work. Nothing particularly special or difficult. I have a little bit of prior experience with Access and VB, but not heaps.

Basically, I've created a tables for parts, companies etc, and am relating all the data together.

At the moment I've made a form that allows you to enter a new part, with Part Number, Description, Category, Supplier, etc.

The complication comes when I want to create an ASSEMBLY of parts. I'd like to create an assembly (which has a lot of similarities to a part, in that it has a part number, description etc), and that assembly needs to store a list of parts that it includes. A simple assembly might include a few items, ie, a bowl of meatballs includes the bowl, a fork, the spaghetti, and 5 meatballs. A more complex assembly (a complete dinner for 5) might include 5 bowls of meatballs (a sub assembly), pepper and salt, 5 glasses and two bottles of coke.

I'm not sure how to best store this assembly data...

I can't really have a table with a finite number of "part" spots because the assemblies get quite large. I'd rather not use an ugly VB macro that stores the PartID's with quantities either, as that could get thoroughly out of hand pretty quickly.

I'm sure there must be a simple method for doing this, but without having a clue as to what it might be called I can't really look for it in help!

Any clues you guys could give me would be great.

Thanks

Col.

View 1 Replies View Related

Data Entry Method

Aug 3, 2006

I want to have my records in my form show the latest entry, not a completely new form. The user will click on the new record button to create a new record but I want the user to be able to see the last record. Anybody know how to do this?

View 14 Replies View Related

'Method Or Data Member Not Found' Please Help@! Am Desperate!!!

Nov 27, 2005

Hi,

Trying to run a template on a new computer.. it works on other computers, but in this case it gives me this compile error.. kind of strange.

It comes up here-

End With
Selection.PasteAndFormat (wdPasteDefault)
Selection.MoveUp Unit:=wdParagraph, Count:=1, Extend:=wdExtend

(.PasteAndFormat) gets highlighted... I'm not that computer savvy... please help!!

Thanks heaps

Ross

View 7 Replies View Related

Modules & VBA :: Method Or Data Member Not Found

Jan 19, 2015

i have the following code in a function but when i want to compile it i have the following code will be blue i have error in this line:

.NamedParameters = True

the error message is this :

method or data member not found

my code is as following:

Function Get_Bearbeiter_Detail(ByVal vBearbeiter_Code As String, Optional ByRef vBearbeiter_Name As String, Optional ByRef vReadOnly_Flag As Boolean, Optional ByRef vAnalyser_Flag As Boolean, Optional ByRef vAdmin_Flag As Boolean) As Boolean
On Error GoTo Err
DoCmd.Hourglass True
Dim rst As ADODB.Recordset

[code].....

View 1 Replies View Related

Forms :: Method Or Data Member Not Found?

Jun 11, 2013

I am receiving the Method or data member not found error message when I attempt to add a new record in form view. I have been working in an old 2002-2003 version of Access until last week when it was converted to 2007. The old version allowed for additions just fine but now after the conversion something is wrong. The code is below. I underlined the line throwing the error message (FindFirst). Code is not my strong suit.

'Open form to new record
gstrCallingForm = Me.Name
strDocName = "frmNewApplicant"

[Code].....

View 14 Replies View Related

Method Or Data Member Not Found Error

Sep 27, 2013

I'm a newbie trying to upgrade a 2003 database to 2010. When I compile this database an error pops up saying "Method or data member not found". This is the code below:

Private Sub CBPrintReq_Click()
On Error GoTo SendPrintError
Dim NewID As String, Notice As String, Temp
Dim CRLF As String * 3
CRLF = Chr$(10) + Chr$(13)
Notice = ""

[Code] ....

View 1 Replies View Related

Compile Error - Method Or Data Member Not Found

Jun 8, 2012

Error: Compile error: Method or data member not found when create Update button

View 7 Replies View Related

Modules & VBA :: Compare Database - Method Or Data Member Not Found

Mar 12, 2014

Compile error: Method or data member not found

Code:
Option Compare Database
Option Explicit
Dim intItems As Integer
Dim strName() As String, datBirthDate() As Date, intAge() As Integer

Private Sub Form_Load()
intItems = Val(InputBox("How many names do you have?", "Name List"))

[Code] .....

View 8 Replies View Related

Forms :: Error (Method Or Data Member Not Found) On Requery

Sep 19, 2014

I have a form (frmTimecardsDataEntry3*) that needs to requery combo boxes to narrow down the selections offered in the dropdown of each combo box.

It is a data entry form. I.e. Dataentry is set to yes.

The ClientName combo box has an after update event which requeries the matter combo box, so that the MatterName combo box dropdown only shows the matters relating to that client. This works just fine.

The MatterName combo box has an after update event which requeries the Rate combo box so that in the Rate combo box dropdown only the hourly charge rates relating to that matter are shown. That works too. So far so good.

I then tried adding another after update event to the MatterName combo box, so that another combo box, Application, was requeried too, so with the Private Sub it looked like:

Rate.Requery
Application.Requery

But this resulted in the error in the title to this post and the debugger highlighted in red the word Requery in the phrase Application.Requery.

I thought maybe Access does not allow two requeries resulting from one after update event, so instead I took Application.Requery out and placed it as an after update event in another combo box which did not have any other after update events to run.

However, this resulted in the same error.So the error appears to have something to do with trying to requery the Application combo box but I cannot see what is causing the error.

The Application combo box SQL is:

SELECT Applications.ApplicationID, [ApplicationDate] & " " & [ApplicationName] AS ApplicationDisplay, Applications.ApplicationDate, Applications.ApplicationName, Applications.MatterName
FROM Applications
WHERE (((Applications.MatterName)=[Forms]![frmTimecardsDataEntry3*]![MatterName]))
ORDER BY Applications.ApplicationDate, Applications.ApplicationName;

This is the same arrangement of SQL that I am using on the other requeried combo boxes that work. When I take the WHERE statement out of the Application SQL and run it the query returns all of the applications.

I am not sure what the error code is trying to tell me about the attempt to requery the Application combo box.

I have a yes/no box in the form and when the firm is first opened it has a small square dot in it, but as soon as any data is entered in the form the dot clears and leaves the usual empty tick box that you would expect to see.

Also, another possible symptom is that I had another version of this form previously working quite well except that when I did several data entries all at once, so I had several forms filled in with different data (before refreshing and thus entering the data in the table), when I scrolled between the forms I kept losing the MatterName data when I scrolled back, and then when I re-entered the ClientName data the correct MatterName data returned without me having to use the dropdown to select it.

I have had an earlier simpler version of this form working for some time, with ClientName requerying MatterName and MatterName requerying Rate, and I am using the same SQL structures in the new form but getting the error in the title to this post and the other isues just described.

View 2 Replies View Related

Forms :: Method Or Data Member Not Found When Inserting Values To A Table

May 13, 2013

I am getting method of data member not found for the following code when inserting values to a table. Form has three frames. Add/Insert is on OnClick Event.

MsgBox "First Value, " & Me.txt_FSNo
CurrentDb.Execute "INSERT INTO BackchargeLog (BC_FSNo, BC_FContract, BC_FPurchaseOrder, BC_FProjectArea, " & _
" BC_FTitle, BC_FDetailDescription, BC_FSupplierToBeCharged, BC_FSupToBeChargedNumber, BC_FSTBCContactName, BC_FSTBCContactNumber, " & _
" BC_FSTBCContactEmail, BC_FIncidentReportedDate, BC_FInitiatedDate, BC_FEstimateAvailable,

[Code] .....

View 7 Replies View Related

Forms :: Display Data In Form As Select Record In Subform In Data Sheet View

Nov 11, 2013

i have a main form named(EMP) i have a subform named(SEMP)with EMPID i have an another form Named(SDetail) with EMPID i want to open form Sdetail with filter records for data select in subform (SEMP) ,EMPID field Subform SEMP in as datasheet view. i can open sdetail for selected records only

View 14 Replies View Related

Queries :: How To Retrieve Only Numeric Data From F1 And Display That Data In A Field

Oct 1, 2013

Background I have a query (Q1) that retrives data from a table (Table 1). One of the fields in Table (F1) contains both text and numeric data (ie: 24 eggs). I want to separate these values in Q1.

Questions
How can i in Q1 retrive only numeric data from F1 and display that data i a field?
How can i in Q1 retrive only text from F1 and display that data i a field?

View 3 Replies View Related

Forms :: Display Existing Data On Data Entry Form

Sep 28, 2014

My db has multiple linked tables. As time passes and work on a project continues data needs to be added to a separate table that is linked to the first table to be populated.

i.e., Initial design data is entered first, when drilling is complete more data is added to a linked table, when drilling is surveyed yet more data is added to the second table.

What I want to be able to do is to query for a particular set of existing design data, display this on a form and on the same line enable data entry to other fields from other tables which are linked to the existing design data.

View 7 Replies View Related

Display Data

Nov 13, 2006

Hi,

I am using a query to print information about customers and products on a report; the query is returning something like this:

Customer---------------------Products
cust1-------------------------------apple
cust1-------------------------------cereal
cust1-------------------------------salad
cust2-------------------------------photos
cust2-------------------------------bananas
However, my client is wanting all the info about each customer displayed in list like this:

Customer----------------------Products
cust1--------------------------------apple------------------cereal-------------------salad
cust2--------------------------------photos-----------------bananas

I can change my tables to reflect product1...productn, but that will break database rules.

Any suggestions please?

Regards,
B

View 7 Replies View Related

Display Data

Dec 28, 2007

I have a table with 2 columns :
ID Code
70010000220002A
70010000220002B
70010000220002C
70010000220019A
70010000220019B
70010000220045AAA
70010000220045BBB
70010000220045CC
70010000220045D
70010000220045E
I need to present this info in this format. Can you help?

ID Code1 Code2 Code3 Code4 Code5
70010000220002ABC
70010000220019AB
70010000220045AAABBBCCDE

Thank you!

View 6 Replies View Related

Display Rows With No Data

Aug 22, 2005

I have a query which is grouped by year, facility name, and billing type and needs to display several columns of aggregate values for each of these, e.g. count of cases, sum of cases reviewed, average length of stay, etc. It would look like this:

2003 ABC Hospital Billed DRG 123 22 6.5
2003 ABC Hospital Billed Per Diem 23 0 4.2
2003 DEF Hospital Billed DRG 456 120 12.3
2003 DEF Hospital Billed Per Diem 56 10 2.1

However, if a facility does not have any Per Diem billings for example, how can I generate a row for it anyway? I cannot use a crosstab since I have multiple different values to display. I tried the following union query:

SELECT YR,FacilityName,BilledDRG,NumberOfCases,AverageLen gthOfStay,CasesReviewed,CasesDenied,AvgOflos,[Billing Eligibility] FROM qryDistHIVCasesStatsDAC
UNION SELECT YR,FacilityName,BilledDRG,0,0,0,0,0,null FROM qryDistHIVCasesStatsDACDRG
UNION SELECT YR,FacilityName,BilledDRG,0,0,0,0,0,null FROM qryDistHIVCasesStatsDACPD
ORDER BY YR, FacilityName, BilledDRG;

where qryDistHIVCasesStatsDAC
is the original query,

qryDistHIVCasesStatsDACDRG shows the year, facility name, and "Billed DRG"
qryDistHIVCasesStatsDACPD shows the year, facility name, and "Billed Per Diem"

but then I would get e.g.
2003 ABC Hospital Billed DRG 123 22 6.5
2003 ABC Hospital Billed DRG 0 0 0
2003 ABC Hospital Billed Per Diem 23 0 4.2
2003 ABC Hospital Billed Per Diem 0 0 0
2003 GHI Hospital Billed DRG 456 120 12.3
2003 GHI Hospital Billed DRG 0 0 0
2003 GHI Hospital Billed Per Diem 0 0 0

what I want is:
2003 ABC Hospital Billed DRG 123 22 6.5
2003 ABC Hospital Billed Per Diem 23 0 4.2
2003 GHI Hospital Billed DRG 456 120 12.3
2003 GHI Hospital Billed Per Diem 0 0 0

In other words, for each year, each facility should have a row "Billed DRG" and a row "Billed Per Diem" and only one row of each.

Thanks for your assistance. I hope I have explained this adequately.

View 5 Replies View Related

Altering Data Display

Mar 12, 2008

I tried to revive an old post in the "General" section with this question, but it doesn't look like many people are looking at it. I figured it wouldn't upset the posting gods too much if I posted it here, since the the question is concerning queries.

I'm starting out with an excel sheet that looks like this:

Company Name..........Employee
Jones Electric............Kyle Brown
Jones Electric............Chris Ford
Jones Electric............Matt Daniels

Is there a way for access to make it look like this?

Company Name..........Employee..........Employee 2..........Employee 3
Jones Electric............Kyle Brown........Chris Ford............Matt Daniels

Thanks a lot, guys. I'll be sure to link the old post to this one.

View 6 Replies View Related

Display Data In A Control

Dec 5, 2005

Hopefully a simple one that is eluding me at the moment.
I have a control on a sub form that refers to a value on another subform. When I enter data in the controls subform it will display the correct answer. However, when I close the form and return to it later the control is blank and will only display the answer if I go into another field on the form and make a modification to the data. It seems that the control will only calculate on an after update event but I need it to be visible at all times when the form is open. I have tried requery on open and on load with no effect.
Any thoughts out there?

Thanks

View 1 Replies View Related

Combo Data Display

Feb 2, 2006

I am fairly new to VBA, having done no fromal training. I have taught myself quite alot and I am pleased with how i am progressing. I am stuck though!

I am building a booking system for a friends business, all free of charge as I believe it's a good project to get experience in VBA.

The booking form has a 'Date' Combo box, 'Name' Combo box and a 'Time' Combo box. The 'Time' Combo box displays times in 10min intervals from 0600 to 2100, and this data is stored in a table called 'tblTimes'. I need to build a query that checks the main table 'tblBooking', for a selected date chosen in the 'Date' Combo box by the user, to see what times have been used up and thus only display, in the 'Time' Combo box, those times not yet used for that particular datedate.

I am sure, to some of you experts out there, that this is quite a simple query. I looki forward to your input.

View 6 Replies View Related

Need An Opinion For Best Way To Display Data

Jul 9, 2006

I have a table that contains 4 columns: index (w/ auto generating number), timestamp, current user, and notes. The notes column is a Memo data type and is used to capture free-form notes typed into a text box.

I would like to display all notes typed by a specific user and do it in a single control, preferably a text box. This way someone can look back over time and review all the notes they typed / added to this table. Is it possible to display multiple rows from a table in a single text box or do I need to use a list box?

View 2 Replies View Related

Display Tbl Data In A Form Using VBA

Feb 27, 2008

I want to display table data in an MS Access form (using a Text box or a grid) using VBA?

Any ideas or examples?

Kind Regards
Richard

View 1 Replies View Related

Display Message When No Data Is Found

Apr 11, 2006

I have a macro in the On No Data event of a report that displays a message when the item number a user requests does not exist in the table being queried.

Now I need to get the same functionality in a form. The form is based on a parameter query with only one criteria [Please enter item number]. The form opens in Edit mode when a valid item number is entered.

I see that there is no On No Data event for either forms or queries, so I'm stumped on how to proceed.

Any and all assistance is appreciated.

View 5 Replies View Related

Using PivotChart To Display Survey Data

Oct 31, 2007

I have this pivot chart (please see attached screenshot) that I was hoping to use to display results of a survey that was conducted by our nonprofit organization. I have it filtering by a few demographics (age, gender, parental status), and then the results of a few other questions below it. My problem is that I'm not sure what results I'm looking at -- whether they're totals of all the responses, just the "true" responses, or...?

The survey asked questions similar to what you see in the field list. Each question is a column header in my table. Then the row headers are each respondent. The choices for answers were "true", "false", or nothing. So in all the cells, i entered t, f, or nothing accordingly.

I'm not sure if I'm not using the pivot chart correctly, or if I didn't design the table for the data correctly.

View 1 Replies View Related

Display A Message To Add Data To Corresponding Table Name

Aug 5, 2005

Hi, does anyone know how to create a query/or form that promts the user with a message box that says "enter table name", from this if the user types "A" then table A will be opened for the user to add data into or if the user types in "B" then table B will be opened for the user to add data into. Ideally I would like a form that opens (either form a or form b) that allows the user to enter the details into the corresponding table (a or b)

Tables A & B are both emty to start of with. The field names in both tables are: user_id, firstname, lastname, date

Please help?

View 2 Replies View Related

Query To Display Data That Does Not Match

Jun 12, 2006

Hi,
I have two tables of data, one is a customer information (membersdata) table and the other is information recived from a bank (bankdata). Each customer has a 'bank description' field in its membersdata table and the bankdata table also has field 'bank description'.
The query I have at the moment gives me back the data that both tables have a matching 'bank description'. The query I want is one that will give me the data from the bankdata table that does not exist in the membersdata table.
So simply put the query I want is the opposite of the one I made with the wizard.

I hope that makes sense?

Any help would be fantastic!

Cheers
Phill

View 9 Replies View Related







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