Tricky Question - Form Part Data Entry, Part Not

Dec 16, 2004

I have what I think is a difficult problem to overcome...

I am designing a form to create an invoice. The user will select a workstream and a date range in form frmInvByHrs. Within this I want two sub-forms, one is frmInvByHrsTsht and the other is frmInvByHrsBill. I want the first one to display all the staff and their hours done, and the second one to be in data entry mode where you can enter the hours you want to bill. Each sub-form is based on a separate query.

Is it possible to do this? ie. to have one sub-form in data entry mode, and the other not? It seems to me that the data entry mode is controlled by the MAIN form regardless of the sub-form settings!

If this is not possible, do you know how I can acheive this?

Thanks

S

View Replies

A 2 Part (Data Entry Form) HELP PLEASE

Oct 3, 2006

Im trying to make a data entry form which will add a new record to a database. My problem is when I associated it with a table. it starts off with a record already populated in the fields. Can someone tell me how to start off with a blank form to add new information.

Part 2

I wish to have a combo box that will drop down with SSN#s and populate the Address field automatically so that a person with additional orders will not have duplicated addresses but just one main address.

Thanking you all in advance!

View 4 Replies View Related

Date Problem - Part Constant - Part Now()

Nov 3, 2006

Hi everyone,

I have refined my query from previous threads to involved a module function. This calculates more acurately no of working days between dates and takes into account a holidays table. (All credit to Arvin Meyer on the module:) )
However because the Leave Year starts at the 1 July and finishes 30 Jun I need to compose the date for any current year Year(Now())

Enclosed scrdmp shows my query design. I can easily get it to work as you see it, but obviously as each year rolls over, the year needs to change.

Have looked at many posts but can't find what I'm looking for. This one will get me over the hurdle.

Many thanks,

View 6 Replies View Related

Modules & VBA :: Save User Entry As Part Of Hyperlink Then Display In Subform

Nov 21, 2014

I have a form with multiple textboxes and comboboxes that allow for user entry, and a subform displaying a table, where the entries from the form are saved and can be retrieved. It's basically a way of creating new task entries and editing existing ones from a single interface.

One of the fields is an "issue number" of sorts, which is a 5-digit code that identifies the task. We have a website where details of each task are stored, and the URL format is akin to this: [URL] ....

The functionality that I'm hoping for is that when the user saves the record, it will be saved as the full link address, by concatenating the static first portion of the address and the code entered by the user. However, I need the table to still only display the code, not the whole link address, and will follow the full address when clicked in the subform table.

View 2 Replies View Related

Part List Data Base

Mar 25, 2006

I am trying to create a database to create a purchase list of parts for a final assembly. There are several subassemblies that make the final unit. There are also subassemblies within subassemblies.

I want to be able to create a list of parts for purchase for the completed unit.

I have a table of part numbers that assigns part numbers to parts as ewell as subassemblies. in this table there is field that designates what type of part it is, System, assembly or base part. I am trying to query the "system" to get a quantity of all base parts contained in it. The feils in the table are part number, part name and what type of part it is.

I am having trouble with the queries or what should be in the table.

View 3 Replies View Related

Return Only Part Of A Large Data Field

Nov 27, 2006

Hey all

I have a table that contains a list of news items. For each item there is a link to an appropriate image and a load of text.

I display a list menu of news items showing the picture and the first few lines of text. At the moment for the first few lines of text I have a separate field and just copy and paste the first few lines of the main article into it.

My question is is there a way where instead of having to have a separate field with just the first few lines in I can somehow just retrieve the first few lines of data from the full article field when displaying the menu listing?

Hope this makes sense, and any ideas greatly appreciated.

Many thanks

View 2 Replies View Related

Import Part Of Data From Excel To Access Use VBA

Apr 23, 2013

Recently I am using this code to import the data in a excel sheet into Access table:

Code:
DoCmd.TransferText acImport, , strcTableName, strFullPath, True

But this will import all the data in that worksheet into the Access table.What I want to implement is to import part of the data. For example, the data I need is start from Row30 till the end, thus I don't need the data from Row1 to Row29.

View 6 Replies View Related

Reports :: Table With Data - Unique Part Of A Record

May 28, 2013

I have a table with data like this

Field_1,Field_2,Field_3
A,B,5
A,B,3
A,C,7
A,C,6
X,Y,4
X,Y,3

I need a report where I can only see

A,B,5
A,C,7
X,Y,4

That is Group by Field_1 and only show the records which has Field_2 with the max. value of Field_3

View 1 Replies View Related

Ok Pull From Form Part 3

Aug 15, 2007

Code:INSERT INTO [Status Log] ( Status, Edit_Date, Event, Claim_ID )SELECT [Status Lookup].Status, Now() AS Expr1, "3rd Party Denial" AS Expr3, [Claim Report Info].[Claims Header].Claim_IDFROM [Status Lookup] RIGHT JOIN ([Claim Report Info] LEFT JOIN [Status Log] ON [Claim Report Info].[Claims Header].Claim_ID = [Status Log].Claim_ID) ON [Status Lookup].status = [Status Log].StatusGROUP BY [Status Lookup].Status, Now(), "3rd Party Denial", [Claim Report Info].[Claims Header].Claim_IDHAVING ((([Status Lookup].Status)=[Forms]![claiminformation]![ReportForm]![reportstatus1]) AND (("3rd Party Denial")="![claiminformation]![ReportForm]![txthiddenvalue]") AND (([Claim Report Info].[Claims Header].Claim_ID)=[Forms]![claiminformation]![ReportForm]![Report_ClaimID]));

here is my current query.
i'm trying to append data to a table from my form.
"![claiminformation]![ReportForm]![txthiddenvalue]"
but since it's my value from txthiddenvalue isn't anywhere in my query how do i get this to work?

View 1 Replies View Related

Not Able To Get Sub-part ID To Show Up In Form

Mar 27, 2013

I have Fields Form in this order:

SubpartID
PrimaryID
Discription
Qty
UnitCost
NetWght

Here is the VBA Code:

Private Sub cboSubpartID_Change()
Me.PrimaryID = Me.cboSubpartID.Column(1)
Me.Discription = Me.cboSubpartID.Column(3)
Me.Qty = Me.cboSubpartID.Column(4)
Me.UnitCost = Me.cboSubpartID.Column(5)
Me.NetWght = Me.cboSubpartID.Column(7)
End Sub

Now the SubpartID is not coming up at all...Its registering the PrimaryID instead. So I changed the Column# Still only getting the PrimaryID number instead the correct one. I changed the lookup on the Table...Still not able to get the SubpartID to show up in the form..

View 1 Replies View Related

Printing A 3 Part Carbon Form

Oct 1, 2005

Looking to print an access 2000 report on a 3 part - 9 1/2" x 4" carbon form. I'm using an Epson LQ-590 dot martrix printer. Does anyone know how I can set this up under the page setup of the report? I'm trying to print an access report I made with comapny and customer name to these 3 part carbon meter tickets. I'm really in a jam. Any help is gratly appreciated. Thanks....

View 2 Replies View Related

Hyperlink To Different Part Of Same (very Long) Form

Sep 16, 2005

I'm writing some "Help" for an Access database that I've created, but lots of others will be using.

All I can think of is to type it all into a form which is then displayed when the user clicks a button I'll create on the menu. As it's going to be a long form, I want to put a "Contents" section at the top, with hyperlinks to relevant sections further down.

Is there a way to make one label (cos that's all the text is) hyperlink to another label in the same form? Or should I be going about this in a completely different way?

I've read a lot of the hyperlinks Q&As in the forums, but haven't found the answer to this yet. Thnaks in advance for any help.

View 4 Replies View Related

Selections In Continous Form Problem, Part II

Oct 27, 2006

Hello,

I have a continuous subform that shows records from a table [not the table the parent form is based on] - a check box, a text field with text, and a blank text field for notes.

When I click on one particular of the checkboxes I see in form view, I can make the notes field/s visible. Unfortunately, that means right now that the fields for all the records become visible.
If at all possible, I would like to set this up so that only one particular text box becomes visible.

Could somebody please tell me if this can be done, and help me do it?

Thanks a lot.

View 6 Replies View Related

Way To Make A Part Of A String That Is Calculated Into Currency Form?

Feb 28, 2012

I have a text box and currently this is my control source

="Testing " & [test]/3
test = 1000 so my text box reports:
Testing 333.333333333333

Is there a way to make it into a form like $333.33...Also is there a way to make [test]/3 come out in a money text form? like "Three hundred thirty three dollars and thirty three cents.

View 7 Replies View Related

Export Part Of The Table Based On User Input Via Form

Aug 23, 2006

hi everybody, im have a database with table called "project". there are many column in this table. my user want to export this table to Excel, but only some of column, with particular order ( depend on him) to analyze in Excel.
he asked me to build a form with a list box, drop box,somthing like this, so he can choose what column to export in what order.
i try to make a query like this: " Select Forms!UserInput.combobox1.value , Forms!UserInput.combobox2.value,etc, From Project" but it wont work.
Dou you have any idea.
thanks in advance

View 2 Replies View Related

Tables :: Auto Fill Part Of Form From Project List Table?

Nov 14, 2012

I have a master list of projects, with project reference number, project name, and nature of project.

I have also got a form for individuals to fill in details of project events, with date, time, name, and two or three other fields - also included are project reference and name. I'd like the name field to be auto filled when the user selects the project reference from a combo box; I think? (the list only shows open projects).

I'd did something similar some years ago in Access 2003 (I think) but cannot figure it out in the version I'm currently using 2010.

View 8 Replies View Related

My First Database Part II

Mar 13, 2006

I am having more trouble with the old database I am trying to make.

Can someone have a look if I attach it?

I don't think the ID fields in each of the three tables are working togehter.

Shouldnt they be the same ID number of each record for that person across the three tables?

Thanks.

View 2 Replies View Related

Part Number DB

Aug 8, 2006

I am trying to create a Part Number Database and want it to start at 100000 instead of 1. Can someone tell me how I can get Access to start there?

TIA.

View 4 Replies View Related

Try To Figure Out What The Last Part Of This Does....

Apr 7, 2008

First time on here and I am looking assistance with the last part of this code. Can someone tell me what this is looking for thanks...

ExlFile.Application.activeworkbook.SaveAs "........Compliance Reports" & Rtn & BU & "-" & Cat & ".xls

View 2 Replies View Related

Updating Only Part Of The Value

Jun 29, 2006

I have a field called images and its name is like abc0001, abc0002 etc, i want to update all the abc to abcd0001, abcd0002 etc, how can I do this using update query or is there any other way to do this, thanks for any help...

View 1 Replies View Related

Displaying Only Part Of A Field

Jul 23, 2005

On a report I have a field that has a value that can be anywhere from 15 to 25 char. Can I set up the report field to only display the 1st 10 char. ?

jon

View 9 Replies View Related

Search On Part Of A Number

Jan 16, 2006

I have a data base with the field named "PartNumber" this is a 13 diget number. How can I search on the last 7 digets only

View 2 Replies View Related

Searching A Part Of Record..

May 27, 2007

Hello. Im new here and also new to both Visual Basic and Access so please be patient with me :)

I've downloaded SearchDB.zip uploaded by agehoops. Its works exactly like its supposed to but I need to update it a bit.

Im making a MovieDatabase and have a table with Orginaltitle, SwedishTitle, Director, Actors and so on. When I search in "Director" for "Francis Ford Coppola" or just "Francis" the movies which is related to him comes up. But when I search for "Ford Coppola" or only "Coppola" nothing comes up. I want the user to have that possibilty to search using the last part of the name too. Is that possible?

When searching with the binocolor icon it works fine when chosing "part of record", i think thats the english translation for "Del av f�lt". I have a swedish acces version so im not so sure but anyhow I think you understand what I mean.

To sum it up I want the ability to search writing only a part of what the record contain including the last part and not only the first part like it is right now.

Appreciate any help!

Regards,
SoloJuve

View 6 Replies View Related

Excel In Access --- Part 2

Feb 13, 2008

Excel in Access (Part 1) (http://www.access-programmers.co.uk/forums/showthread.php?p=671226)
Excel in Access (Part 3) (http://www.access-programmers.co.uk/forums/showthread.php?t=143970)

Video Version HERE: (http://www.access-programmers.co.uk/forums/showthread.php?t=144045)

How to use the Normalization Form (http://www.access-programmers.co.uk/forums/showthread.php?t=143983)

In Excel in Access (Part 1), we went from this:

http://i185.photobucket.com/albums/x317/UncleGizmo/StudentTableBoolean_2.png

To this:

http://i185.photobucket.com/albums/x317/UncleGizmo/StudentTableTransposed2.png

This was achieved with a form based tool available to DOWNLOAD here. (http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=20619&d=1202664804)

See instructions on its use here: (http://www.access-programmers.co.uk/forums/showthread.php?t=143983)

However you may be looking at the new resultant table and wondering what on earth to do with it. I hope to take you through the process of making it into something useful in this thread.

The first thing you will notice is that where the check box is not checked, then that whole row is redundant, for instance there’s no need to record that ID number “1” --- “Has Not” taken Maths, English, Geography, Physics etc, it would suffice just to record the subjects that have been taken , In this case Biology, PT and Social. Looking at those entries in particular, then a general rule of logic can be defined, “delete all the rows where the check boxes are false”.

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1b.png

Once you have deleted all of those rows,

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1c.png

then it becomes obvious that the check boxes themselves which now “All” contain a true value are also redundant, they can be deleted just leaving you the text entry identifying the subject taken by each student.

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1d.png

Using the “relational” properties of the database that is one more thing you can do which will improve efficiency and that is to replace each text entry --- Maths, English, Geography, Physics etc, with a number linking that field to a look up table.

First of all you need to create a look up table; this can be done by applying a create table query to extract just the unique values for the “subject” There is a video showing how to do this here: (At time index 1min) (http://www.viddler.com/explore/TonyHine/videos/67/fullscreen)

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1e.png

This unique list should be called “tblSubject” this table is not quite finished, you need to add an identity column to the left of the text representing the individual subject, this identity will then appear in the previous table.

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1f.png

Once you have completed the “look up table” you then need to replace the entries in the student subject table “tblStudentSubject” where it shows subject in text form with the number representing the link to the look up table. This is the query:

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1g.png

And here is the new column created:

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1h.png

This way your design changes to the table are making it much more efficient, holding the same information but with less data.

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm_1k.png

View 4 Replies View Related

Excel In Access --- Part 3

Feb 19, 2008

Excel in Access (Part 1) (http://www.access-programmers.co.uk/forums/showthread.php?p=671226)
Excel in Access (Part 2) (http://www.access-programmers.co.uk/forums/showthread.php?t=143607)

Video Version HERE: (http://msaccesshintsandtips.ning.com/profiles/blog/show?id=948619%3ABlogPost%3A7031)

How to use the Normalization Form (http://www.access-programmers.co.uk/forums/showthread.php?t=143983)

Using the normalization form --- Download Here (http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=20619&d=1202664804) we converted part of a spreadsheet type table into the beginnings of a relational table.

From this table we derived a “look up table” now giving us a total of three tables, the remains of the first table, “tblStudent” (the student names), the next table “tblStudentSubject” stores the subject(s) related to each student, and finally a third table, “tblSubject” a “look-up table” to store the actual subject description.

http://i185.photobucket.com/albums/x317/UncleGizmo/ThreeTables.png

From the table “tblStudentSubject” we created a form in datasheet view:

http://i185.photobucket.com/albums/x317/UncleGizmo/DataSheetForm.png

Now all we need do is combine this datasheet view form with a form based on the students list, and this will give us a form for correctly displaying the student names and the subject(S) the student is taking in one Form:

Using the wizard create a basic form from the student table and name it “frmStudent” arrange its size so it has some open space as shown.

http://i185.photobucket.com/albums/x317/UncleGizmo/StudentForm.png

Now open “frmStudent” in design view

http://i185.photobucket.com/albums/x317/UncleGizmo/DragSub_1.png

And drag the subform “sfrmlStudentSubject” into the clear area on the student form “frmStudent”

http://i185.photobucket.com/albums/x317/UncleGizmo/DragSub_2.png

You may wish to delete the text box, you don’t have to but I usually find it looks better without it.

http://i185.photobucket.com/albums/x317/UncleGizmo/DragSub_3.png

Size the form to suit

http://i185.photobucket.com/albums/x317/UncleGizmo/DragSub_4.png

Now save the form and have a look, you will notice that it incorrectly shows all of the records in the subform,

http://i185.photobucket.com/albums/x317/UncleGizmo/DragSub_5.png

Now the next bit is tricky, for two reasons, the form isn’t really on top of the other form, it actually sits in a subform window and you need to gain access to the properties of this subform window by clicking on the tiny line that you can just see around your subform. This can be a difficult task to master first time.

http://i185.photobucket.com/albums/x317/UncleGizmo/DragSub_6.png

Now open the “subform field linker” dialog box by clicking on the ellipsis (…)

http://i185.photobucket.com/albums/x317/UncleGizmo/DragSub_7.png

Phone: +44 1635 522233
Mobile: +44 7747 018875
Email: email@tonyhine.co.uk

Web: http://msaccesshintsandtips.ning.com

View 1 Replies View Related

Filtering Out Part Of A Field

Apr 7, 2008

Hi,

Apologies, I have no idea if this should go in reports, queries, macros or modules and VBA as I'm a bit stuck but hopefully it's fairly simple.

I've been teaching myself access and it's been going well. What I have now been asked to do is produce a report that generates the shift patterns for everyone in the office as an HTML document. Now, the data is all exported from another program and I've had no problem getting the data into access easily. The problem I have is the format some of the data is in.

The major one that I need to solve is showing what time people are meant to take their lunch break each day. The field for break is filled in in the following format.

07/04/2008 12:45:00

Now, I have the date from elsewhere so I really don't want the date to show up so I need something that removes the date from this field. Is this going to be easy to do? (Ideally I'd like it so that the above example actually just returned 12:45 but if it has the 00 on the end that would not be the end of the world)

Apologies if this is in the wrong part of your forum.

View 3 Replies View Related