Ive been converting .xls files to Access database files. I would like to use ACCESS to develop the Reports but the client wants the Reports to look like those in EXCEL..eg. where you have lines between rows and columns. If I could give my Access Reports the same look and feel, I could wean these guys off of Excel and into the wonderful world of relational models.
Does anyone have sqlcode or tricks I might use to create the Excel 'look alike' report in Access?
I'm currently working with a form, which is in datasheet view. I have many rows which are combo boxes (yes/no), and the name is rather long. So each line (each row) spreads on to 2-3 pages to the right.What I would like to do is make the namebar, on top of every column, a little bit higher, so the name would be split into two lines, or three. Allowing me to make the width allot smaller.Here is an example of my problem:http://213.213.137.96/~terminal/columns.jpgSo my question is, can I change the height of the column name? Or is there some trick I can use?regardsFrímann Kjerúlf
Does 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.
I have a database of purchase orders Many of the purchase orders have a revision No against them, eg:-
Purchase Order No / Line No / Revision No / Value 1001 / 001 / 00 / £50 1001 / 001 / 01 / £100 1001 / 001 / 02 / £200
I am trying to find a way to write a query that will show me the actual value of the final revised value of each Purchase order line ie: the answer to above is
Any idea how I can display this information a lot neater?
Its a bunch of check boxes (I wasn't sure how to go about doing this without them, as they can choose multiple things, if it was just 1, I would have used a dropdown).
I've been trying to fiddle with this for a while now with no good ideas coming to mind.
Anyone have any ideas or examples of how I could go about this?
I am trying to use check boxes as a yes/no answer about whether members have completed training modules, and bind them to a table.
I get this error when tick the boxes, and try to close the form; "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. (Error 3022)"
When I reopen the form the check boxes are greyed out until i tick them (not getting values from table) :confused:
I have a form that uses checkboxes to list all the fields in a table. How would I create a query based on that form?
For example - Field Names - RMA_Num, Qty, Date_Rec, Part_Num, Desc, CC_Primary, CC_Secondary, CC_Tertiary, OF_Appearance
A user may choose to see Qty, Part_num, CC_Primary, CC_Secondary, and CC_Tertiary. How would I set up the query?
For testing I tried having RMA_Num, Qty, and Date_Rec in a query. I set the criteria for RMA_Num as IIf([Forms]![frm_meta]![Check0]=True,[tbl_Mfg_RMAData]![RMA_Num])
With the box checked the query will return results for all the fields. But if the box is unchecked the query returns nothing.
I have 4 check boxes represent 4 grade levels. When I click on a grade I have a query run for me a list of all 9th graders or 10th graders or both together. When I run the form for the first time, all four boxes are check, when I unclick all of them and I click which ones I want the form does not work. But if I leave them click the report will work. Basically what is happening is when I unclick them, the lose their value. I have the check box set up with a Default Value as "09" or "10" base on what Grade Level there is. So my two questions are, how do I keep the value of the check boxes after I unclick and click again and Secondly, is there a way to have the boxes unchecked when I run the program?
I have form, with a number of orders on there, i wanted to be able to give the user the option to select all the orders and update each record, however when i give the user the option to seleect all the orders on the first line is updated. how can i get all the records to be updated the code i am using is shown below, any help will be greatly appreciated.
Dim db As DAO.Database Dim String2 As Integer Dim i As Integer Dim rs As DAO.Recordset Dim StrSQL As String
Set db = CurrentDb Set rs = db.OpenRecordset("kell")
For i = 1 To Me.Quantity Stringy2 = InputBox("The Cylinder/Cylinders Will Be with the driver from The Specified Date Below:-", "Spec Gas 2006, (DD / MM / YY)", Me!Text68 & "")
If StrPtr(Stringy2) <> 0 Then rs.AddNew rs![Line Number] = Me![Line Number] rs![Time of Transaction] = Me![Transaction Date] rs![Cylinder Barcode Label] = Me![Cylinder Barcode Label] rs![Cylinder Number] = Me![Cylinder Number] rs![ProdNo] = Me![ProdNo] rs![Status] = Me![Status] rs![AberdeenWONumber] = Me![AberdeenWONumber] rs![Works Order Number] = Me![Works Order Number] rs![CustNo] = Me![CustNo] rs![Customer Order Number] = Me![Customer Order Number] rs![Date of Transaction] = Stringy2 rs![User name] = Me![User name] rs![Employee ID] = Me![Empoyee ID] rs![A Number] = Me![A Number] rs![New Status] = "With Driver" rs![Date of Transaction] = Me!Text68 Me.Text71 = "With Driver" Me.Text71.ForeColor = vbRed Me.Text74 = Me.Text68 rs.Update MsgBox "The cylinder is now with the driver", vbInformation, "Returned Successfully"
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.
Hi. (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??
Is 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)"
Hi, 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
I 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.
How 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.
Is 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'
Sorry, but this is killing me. I can't find anything in the archive which directly relates.
And it's complicated. I'll try to simplify.
In a nutshell:
As I scroll each Employee on a Parent form, I'd like a subform with functionality to check off any Certifications earned by this person and write the EmployeeID and CertificationID to a junction table.
Seems to me it should be simple, but...
Anyway, here is the probably overcomplicated version here:
The one side tables are 1. Employees and 2. Certifications The junction table records which certifications employees possess. This table contains some Boolean fields.
The Parent form knows the EmployeeID.
My goal is to create a subform on which to display the full list of Certifications, something similar to the attached image, with a button to add an EmployeeID to the junction table AND tick off the Boolean checkboxes.
I've based the subform on a query showing ALL Certifications and all (Junction) records where there is a match
Because the junction table only stores related Employees and Certifications as entered, the checkboxes on my subform cannot be bound directly to the fields in the junction table and, at the same time, allow me to check off the Booleans.
Perhaps a little db redesign? Any help greatly appreciated.
Let me just start off by saying, I don't have any code to post as it is just an idea I have.
This is a Lease return project for work. We have an excel sheet that is broken up into tabs. Master List, Not Returned and then a tab for every month.
Here is what I would like to do. If someone checks the box that says the leased computer was not returned, can I grab a certain batch of fields to automatically populate another Tab in this Access 2003 Form?
The second part to this would be if a person unchecks "Not Returned" in the Not Returned Tab, can I get that record automatically removed from that list view?
Similar principle for the Monthly shipping by a certain date. If the user enters in a shipped Date by say March 1, is there any way to populate a another tab into a list view?
Thanks for any advice that you gentlemen and ladies can provide.
i have checkboxes on a form and want to run a query based on the amount of times the checkbox(es) have been selected...
i have done this and attached a report however because the value of the checkboxes is -1 obviuosly the sum of this is a negative number and so on the report the total selcted is negative....
is there a way to change these to positive numbers...
The other day I check with various people on how I might get column information added together as it relates to checkboxes. Yet, I am still having trouble making this work, please read the following. Any help is appreciated.
Example: Item A (if checked)= 33%, Item B (if checked)= 33%, Item C (if checked)= 33%. Once adding (if A & B are checked) shows that I have 66% completion on that particular project.
I was instructed to...........create a text box on a form, set the format property to 'Percent' and the 'Control source' can look like this:
I am new to Access coding. I'm trying to do the following in Access 2000.
I have a form which includes some tabs. On one tab I would like to display a list of items from an Access lookup table with a checkbox next to each item. The list needs to be drawn dynamically from the table since the table contents can change. I tried using the subform/subreport control with a querry as the source object but the display is not very nice. Basicly I want the tab to look like the picture enclosed but dynamically drawn from the values in the lookup table.
The other day I check with various people on how I might get column information added together as it relates to checkboxes. Yet, I am still having trouble making this work, please read the following. Any help is appreciated.
Example: Item A (if checked)= 33%, Item B (if checked)= 33%, Item C (if checked)= 33%. Once adding (if A & B are checked) shows that I have 66% completion on that particular project.
I was instructed to...........create a text box on a form, set the format property to 'Percent' and the 'Control source' can look like this:
