I have three account types, 110 fiscal months, seven types of fees each associated with a cost. That's 2310 pieces of data if I enter the information with the collumns: AccKey, DateKey, FeeDesc, FeeCost (e.g. For account type one on Fiscal month Jan '11, an overdraft fee was $10). I have all the data on an excel sheet, but it is formatted so that each fiscal year is separate. Is there a way for me to enter this info quickly?
View RepliesI am working on a forecasting report that has many values, mostly in the millions of dollars. I would like to display my $ fields in the thousands of $ so that I can make the text font larger and most easily readable. How do I do this so that instead of, for instance, $2,259,123, I display $2,259.
View 6 Replies View RelatedI'm trying to follow Allen Browne's - Combos with Tens of Thousands of Records [URL] ....
However, I keep getting the error...
Compile Error:
Invalid use of Me keyword
(This being a new module)
That's how it shows in his code (the use of me.comboname.rowsource) but it's not working for me.
I am trying to make sure that my double will have a comma for thousands, but will also be able to display more than 2 decimal places (probably 4).
I am struggling with what format to use - if the number doesn't have any decimal places, the point is still put in.
#,##0.####
Examples:
23.2 = 23.2
64587.255 = 64,587.255
5000 = 5,000.
I am making a database and I require a box in a form where when I press a key, it enters the drink name, price, and stockID. It should also keep a running total of the price and make a subtotal where I can then input the cash given.
Can anyone help? How do I make the box?
Thanks,
Fred
I have to create a database with more than ten thousand records. There is a field on which image by clicking the image to be displayed with the default program based on the image on which you clicked.
Code:
Private Sub Campo1_Click()
Dim L As Long
L = ShellExecute(0, "Open", """" & "C:UsersNickDesktopDocumentiPicturesDioDiego.jpg" & """", vbNullString, vbNullString, 1)
End Sub
When onClick event happens on the image is displayed the same image regardless of the record on which you clicked. How do I change the code to open the image of the field that was clicked?
I'm wondering if there is a way in Access 2013 to - for example - enter a value in a date field and then highlight it and drag it down to populate all the records in the table with that value, as can be done in Excel?
View 2 Replies View RelatedHello Ladies & Gentlemen,
I was trying to access this particular MS-ACCESS file which serves as a DB for a software. But the file opens and closes in a split of a second and was impossible to view its structure. :mad:
I beleive it's made to respond so by the programmers in order to hide the content. Can anyone please help me open this file? PLEASE...
Teddo
All I have taken over a database. It has dozens of queries. Is there a tool or code that I can use that would quickly diagram the querie like a flowchart telling me what queries are related and the steps and so on.
View 1 Replies View RelatedI have a file with 45 columns and I need to be able to make 40 columns quickly dis-appear and re-appear. When I search for responses to similar questions I get references to "Horizontal scroll bar and List Box control" which I do not know how to find and/or use.
View 4 Replies View RelatedHi Guys and Girls.
I have about 100 or so tables that I need to append back into one table :eek:
However all of these 100 tables all begin with the number 100 at the beggining. I know that you can append tables - but as far as I know you can only do one at a time. Is there any easy way to do this - for example writing a small SQL statement - saying select all tables that begin with 100* and then append into a master table :confused:
Alternatively are there any programs on the net that can do this (I just wrote a massive macro to import them from a text file in to access- not realising this problem would happen!) :(
Unfortunately each of the tables has the first row as the column heading too?
Any help would be much appreciated!!
Cuurently using Access 97 though.
I have Access as front end and SQL Server as back end. The Access application is placed on a common network drive for theusers to access it. The compact on close option is enabled when the access application is closed.
I have a local copy of the access app. When I close the app, it takes ony a few seconds. But when on a network drive, it is taking 2 mins.I just wanted to know if the time taken to close the application on the network drive can be brought down without disabling the compact on close option.
Situation
My database stores course information for faculty in my department and prints out various reports based on that information.
The 2 mandatory fields in the form are [AcademicYear] and as they create the potential for classes to be added to the curriculum.
Question
Is there a way to add multiple records to the db based on the which year and instructor combinations were use prior?
[I]ex.
2007/2008, prof-a
2007/2008, prof-b
2007/2008, prof-c
2007/2008, prof-d
This represents the 2007/2008 school year where professors a through d taught courses. Is there a way to add records for another academic year so that:
2008/2009, prof-a
2008/2009, prof-b
2008/2009, prof-c
2008/2009, prof-d
appear with just the press of a button?
I don't know if I'm being clear enough. :p
Let'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.
Hi 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
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.
Any help would be appreciated.
Mike
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.
View 5 Replies View RelatedIs 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 RelatedIn 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 RelatedHow 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 RelatedRather 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
can you get automatic ruler lines to display on a report after each record is displayed?
View 4 Replies View RelatedHi, 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