Ruler Lines On Form
Sep 5, 2005can you get automatic ruler lines to display on a report after each record is displayed?
View Replies
ADVERTISEMENT
Loosing Lines On Main Form After Navigating To Another Tab
Sep 11, 2006I have a main form that displays four lines of data. I have a tab control with 3 tabs. The form displays perfectly until I navigate to one of the other tabs and back to the main tab. It appears to scroll down a couple of lines and I loose the top line of data.
Any idea what is happening or how to stop it?
:confused:
Forms :: Add Record Lines To Spreadsheet Form
Apr 25, 2013I want to create an access spreadsheet form in which the user can add data, which will be - after being processed - added to a database table. The spreadsheet form is for this reason not directly linked to a database table.
In the spreadsheet that I actually have, I manage to copy paste data from an Excel spreadsheet. However, only the first row is pasted. Access doesn't add new record lines for the other rows of my spreadsheet.
How can I make Access add record lines in function of the data on that is pasted? Or if this is not possible, how can I add sufficient additional lines myself?
Forms :: Dividing Lines In Form But Not Report
Aug 12, 2014I have a form that I'm using as a subform as well as a subreport.
I would like to have dividing lines in the subform, but not the subreport.
Is there any way of doing this other than just creating a duplicate form with a different name?
Multiple Lines In Order Form From Single Database
Feb 28, 2005I have 2 databases Product, with 3 entries ProdID, ProdName and UnitCost.
2nd database Order has Order ID, ProdName, UnitCost, Quantity, SaleDate and Total.
I want to create a form to input data into the Order databse that allows me to enter several rows using the data from the product table by selecting ProdName(Product) from list and UnitCost(Product) being inserted into each row automatically as a new ProdName is selected.
Can anyone hsuggest how best to do this.
Modules & VBA :: Getting Blank Lines In Table Even Though Form Is Unbound
Jun 24, 2013I have created a forum that all fields are unbound. On completing it is written to the table using a RunSQL command. This writes to the table with no problem but when it does so it is creating another entry with zero content. This is the save steps with open new form
Code:
Private Sub SaveRecordAddNew_Click()
Call PreSaveCheck
If Me.saveCheck = False Then
Exit Sub
Else
Call WriteToTable
[Code] .....
Forms :: Duplicate Lines In Multiple Form And Query
Jul 8, 2015The purpose of my database is to keep a record of training activities undertaken by staff. There is therefore a multiple form which displays, for a specified worker, the list of all the required activities. Each line has a button which opens another form to allow an activity to be started (together with start date and other info). The main tables are Worker, Activities, and a junction table Worker2Activities. On closing the second form and refreshing the first one, the started activity is correctly recorded, but on as many lines as there are staff on the course. To make matters worse, these also appear when i then select another worker (and if i create another worker, the number of lines goes up by one for all of them). The Worker2Activities table correctly show one new record created
View 3 Replies View RelatedHide Selection Option On Form By Making Lines On A Table INACTIVE
Jan 15, 2014I have several tables linking our employees to certain supervisors, etc.On the Form, there is a drop down with all employees listed that someone can select and then enter the stats required. When someone leaves the firm, I want to remove them from the form dropdown list, but not delete them from the corresponding table. I have seen this in other databases where they someone added an 'Inactive' column with a Yes/No response and when you selected the inactive - yes, that name would disappear from the form when people select names from a dropdown to enter stats.how to make the names disappear from the view in a form, but not in the table related to that form?
View 6 Replies View RelatedForms :: Limiting Continues Form To Accept 7 Lines And Dating Them With Current Week?
Jul 29, 2013Form info
1st Form Name: Mainform
Text to enter employee ID : empid
Sub form within Mainform: SFTimesheet (continues form)
text to enter: Timein, Break, Timeout
SFTimesheet shows and accept entries for each employee called using the text empid, on the mainform
I wanted the subform to show 7 days /lines starting from Sunday to Saturday of current week and dating the text "Timein" accordingly. When employee enteres an entry on the 7th Line, it should give them a new 7 lines for the new week to begin.
Deleting Lines
Jun 18, 2007Let's say we have a table:
Sipping branchReceiving BranchProduct #Qty to ship
a c PR1 43
a d PR1 25
a k PR1 1
....
Now I want to delete all lines that have same product code and shipping branch as a privous line.
So the only max amounts for each product and each shipping branch will remain.
How to delete those lines?
Thank you.
Count Lines
Aug 16, 2007Hi there,
LEts say I have a table
branch item $COGS
we have lots of same items having different $COGS in different branches and all of them are on one table
I sorted that descending by $COGS.
Now I want to pick for each item only 4 first lines having bigger $COGS.
The rest of the lines should be deleted.
How I can do that?
Thanks
How Add Lines To Table?
Oct 20, 2006Hi. (I already ask how to delete rows but it looks too hard to make so I invent new idea)
How I can add lines (INSERT INTO) into table so that Access does not add lines which already are in the table??
Two Lines In A Message Box
Mar 3, 2006Is it possible to create a message box with two lines?
Also I want to make a reference to the valuein a text box in the message box.
This is my code at present:
If MsgBox("ARE YOU SURE YOU WANT TO DELETE THE WHOLE EXERCISE?", vbYesNo + vbQuestion, "Warning") = vbYes Then
CurrentDb.Execute "DELETE FROM ExerciseNametbl WHERE ExerciseName = " & Chr(34) & Me.ExerciseName & Chr(34), dbFailOnError
Me.ExerciseName.Requery
Else
Exit Sub
End If
What I would like is:
"Are you sure you want to delete (The value of comboExerciseName)"
List Box - Possible More Lines?
Sep 5, 2006Hi, sorry my english, but I will try to explain what I try to do.
In my database I have a form, where is a listbox. In this listbox are names of documents. Problem is that the name of each document is so long (two or three lines on monitor) so it is not possible to fit in, because listbox has always only one line for each document.
It is possible to set up listbox to get more lines for each item ?
I will be very happy if somebody help me with it. Thank you very much.
Jirka
Blank Lines
Aug 17, 2004I am working with an access table populated from an excel spreadsheet due to its source if a person has more than one line of data the fileds are left blank.
Example:
ID Name Date diagnosis
01 Smith, David 07/01/2004 sore throat
02 Strep Throat
03 Broken arm
For Smith, David he had 3 diagnosis but the field date and name are blank as they would have been the same as ID 01. I have written a query to populate the blank fields:
IIF([name] is null, dlookup("[name]", "tblDiagnosisUnder16final","[Id]=" & [id]-1),[name]) This works great for lines with only one blank, but in the above example for ID 03 the name field stays blank as it is looking at field 02 which is blank in the table.
What I need is a loop to keep moving up the table until it finds a field that <> Null. I assum I should write a function and palce it in the if statement above where the -1 is but I am strugling with comming up with a solution.
Any help would be appreciated.
Mike
Vertical Lines
Nov 7, 2005How would I go about getting vertical lines as column seperators down the entire page. The problem I run into is every time the row size changes there's a break in the column dividers. Someone suggested using a function in the On Print event for the report, but there is no OnPrint field in the event tab of the reports properties. If anyone ever did anything like this before, please let me know.
View 5 Replies View RelatedMemo Box New Lines?
Nov 7, 2006Is there any way of making a comments box (memo) have the functionality to press return and start on a fresh line as it all seems to run into one 'indecipherable blob'
View 1 Replies View RelatedCount Of Query Lines
Mar 12, 2007In a query, how do I do a count of the number of lines that appear in the query? Not the number of records, because the query itself is grouped. The results are in order, highest to lowest, and I want to see just the top 50.
View 3 Replies View RelatedNumbering Lines In A Query
Mar 13, 2007How do I number the lines in a query? I have a 'Top 50' query, and I want to number the lines 1 through 50.
View 6 Replies View RelatedVertical Lines On Forms
Feb 10, 2005Rather than manually draw vertical lines on my forms, I'm looking for a way to generate vertical lines using VBA code. Has anyone done this?
Thanks,
pc
Error Message On 2 Lines
Sep 17, 2006Hi, I have the following code to display the message as in the picture
Private Sub Staff_Number_NotInList(NewData As String, Response As Integer)
MsgBox "CREW MEMBER NOT IN LIST - Double clic on this field to add a Crew Member"
Response = acDataErrContinue
End Sub
What I wouldlike to do is get the message written on 2 lines instead of 1!!!
Thanks
M
Multiple Lines In Text Box
Dec 14, 2004i'm no noob, but i'm also not the expert, what i'm trying to do is this,
i'm taking multiple string out of an recordset and putting them in one big text box
but the problem is that after every record there has to be an enter in the text box
So for example:
record 1 =
-bla bla bla
-tja tja tja
record 2 =
-waa waa
my result in the text box must be:
-bla bla bla
-tja tja tja
-waa waa
and not (like it is now):
-bla bla bla
-tja tja tja -waa waa
who has a clue? chr(11) & chr(13) do not work, i activated "on enter go to next line"
thx in advance for helping out
Import Txt File But NOT The First Three Lines?
Oct 19, 2005I have a csv file, I am able to import it using the vba commande docmd.TransferText action. But the first three lines are made up of headers. I do not want to import these.
xxxxx,
xxxxx,
Field1, Field2, Fileld3,
Is there a way that I skip out the first 3 lines of the text file? ie only import from row 4 onwards?
Please Help
My current transfer method also creates a table of errors for the first three lines (as they do not match the data type spoecified by the target table). It also creates a whole lot of null fields in the first three rows of the table. I am running a loop for a whole lot of csv files so you can imagine I'm generating a lot of error import table. If I could import only rows 4 onwards there would be peace in the universe!
Need To Make My Report Look Like An Excel With Lines In It!
Jun 15, 2006Does anyone know how to make a report have lines in it like excel can do when you print out. My boss likes to read this data with lines seperating stuff. Thanks.
View 3 Replies View RelatedAddress Lines And Carriage Returns
Aug 11, 2007I want my query to output an address in one field with carriage returns, where the address lines in the source table are held in individual fields.
So I try...
SELECT [Address1] & Chr$(13) & [Address2] & Chr$(13) & [Address3] etc..
This does not work.
However, if I use a text box on a form, with "New Line in Field" set, and then in code use Sendkeys to post the address and the carriage returns as above, it does work.
Can this be done simply in a query? If so how?
Blank Address Lines In Mailmerge
Dec 27, 2007I am trying to generate letters from ACC2003 db into Word2003. Reason for Word is so client can edit letters if required.
I have set up a maketable query to generate a temporary table in the Db and the mailmerge master document all formatted and pointed at the temporary table. I still need to get the automation running so that the letters merge and print on a command button.
My immediate issue is that the address lines are intentionally spread across 5 fields Addr1, Addr2, Addr3, Town, Postcode. Not all fields in every record are full, and with the query it would be impossible to eliminate fields on the chance they might be empty.
As a result my mailmerge has blank address lines which do not look professional.
Can anyone point me to how I might solve this given my proposed use - if it was a report then I have a little code module that neatly eliminates blank lines but I cannot see how I could integrate this into the mailmerge process.
Thanks for any help or pointers