Access 2010
I have a report with some text boxes on it. Sometimes the text in these boxes can be a very long string of characters (maybe a path to some folder). In this case I do not want the text box to grow. I just want the report to show me the right-hand side of this path and cut off the left. How do I do this when still aligning my text to the left?
Hi Guys,
You know how you get the form header/detail/footer sections on a form. Well, how can you make text appear down the side (ie so that it overlaps all of the header/detail/footer sections).
Take a look at my drawing, it will explain it better...
So I'm trying to manipulate Access to create a Directory for my church. I'm trying to get a report to show the church staff, which I was able to do, but I was wondering, is it possible to get the records to show side by side instead of one on top of the other?
I included a picture of the design view showing what I would like to see. Excuse the way the numbers are written, it's hard to write with a mouse.
Form with three sections. I have three queries selecting different set of set in a table, I would like to show all three in a form side by side. How can I do this? I use form wizard bit it only uses one query as a source.
View 2 Replies View RelatedI have split my database, the data is in a DB on the server and the forms, reports, etc is on the client desktop. My question is "Is there an advantage to having all of my combo box queries (Lookups) on the server side (defined in the table as a combo lookup) or should I put the all on the form so that they reside in client side DB.
View 7 Replies View RelatedHi,
I would like to create an application with a left side tree menu.
Each leaf of the tree should open a form or launch a procedure.
The branches could expand or collapse.
Nodes could have pics.
There must be a couple of VAB examples. Would you recommend me some of the best ones ?
Thanks
Hi,
I want to Delete only FK on the many side first and the record on the one side by one click of a button. I wrote some code which sometimes works and sometimes it does not!!
I wonder if any one have a better idea or doing this please?
Private Sub Delete_Click()
Dim db As DAO.Database, rs As DAO.Recordset
Dim n As Integer, i As Integer
Dim vStart As Integer
Dim vEnd As Integer
Dim vSite As Integer
Dim vRCCID As Integer
vSite = Forms![frmSite].Form![SiteID]
vRCCID = Forms![frmSite]![Roads Construction Consent].Form![RCCID]
vStart = Me.PhaseStart - 1
vEnd = Me.PhaseEnd + 1
Set db = CurrentDb
Set rs = db.OpenRecordset("tblPhase")
rs.MoveLast
n = rs.RecordCount
rs.MoveFirst
If n > 0 Then
For i = 1 To n
If rs![SiteID] = vSite Then
If rs![PhaseNumber] > vStart And rs![PhaseNumber] < vEnd Then
rs.Edit
rs![RCCID] = Null
rs.Update
End If
End If
rs.MoveNext
Next i
End If
rs.Close
db.Close
Set db = Nothing
Set rs = Nothing
'/////////////////////////////////////////////
DoCmd.RunSQL "DELETE RCCID FROM tblRCC WHERE RCCID = " & vRCCID & ""
'//////////////////////////////////////////////
End Sub
tblRCC is the one side of the relationship and tblPhase is the many side.
Any help will be very much appreciated.
B
I have a subform that�s in datasheet view, is there a way to align the vertical scroll bar to the left side?
Using:
Win 7
Access 2010
I have several comboxes where I'm using date/time input masks. When I go to enter data in the field the cursor is situated at the right end of the box. I have to backspace to the beginning of the field to enter the data. How do I position the cursor to the beginning (left side) of the field?
View 3 Replies View RelatedHello the problem I am having is that when I imported data from excel, it somehow placed carraige return at the end of the text box ( this is what I believe), this is a problem because in that field is a drop down box and it complains about my value not being valid. I press the del key behind the value and it doesnt complain. Can anyone help me?
View 1 Replies View RelatedI have two tables which I pull records from. One table has a list of sections. The other table is a list of chapters.
One chapter has many sections.
I have the sections table populated, and want to show all of the sections, even if they are not currently assigned to a chapter.
Currently only the sections which have a chapter show up in my query.
I know this is really simple to do ..... I'm just drawing a blank on it!
Any help would be appreciated.
Gordon
Hi
I'm looking to build a product generator - so user will select from a series of combo box's (Bed, (could be 5000, 5100 etc) Plug,(could be A,B,C,D) Castor could be ZZ, AA, EE,etc) and a code will be generated. (i.e 5100CEE)
I can achieve this - but I've been thrown one of those balls that are curved. The end user also wants a picture of each part of the code to be outputed on the final order form - and here's where I'm struggling - as if I pull from my dumb form (with dumb combo box's) - I've nothing to link to - and if I link to a table, I get zillions of records.
Any advise, general direction, gratefully accepted.
Cheers
Paul
Reet, I have a problem i have been pondering over for the last hour or so and im not sure the best way to do this! Its slightly tricky to explain so bare with me!
So I've made a Software Licensing Database which tracks licenses etc.. Its based information provided by another company which handles all my companies data handling etc..
Ok so in this database it tracks all installs and compares them against licenses. But this 3rd party company doesnt make life easy and sporadically buy licenses thus there's are always licensing issues here and there.. hence wantign the db to keep track. However rather than having a simple 10 licenses, 10 intalls for abit of software, they have created an entity called a Delta which is hand-me-down licenses. i.e.
Adobe Acrobat Pro 8:
100 Licenses | 50 Installs | 50 License Delta
Adobe Acrobat Pro 7:
25 Licenses | 93 Installs | -18 License Delta
So as you can see the Delta is Licenses available for lower versions & editions of software. So where I get these reports on a figures basis my boss wants me to physically give each install a license. Thus thats me breaking down a number of License into a singular form and assigning it to a specific person. Which is all done thats easy enough my problem is Incorporating the delta for that piece of software. So above as you can see for Adobe Acrobat Pro 7 I can happily assign those 25 Licenses to 25 of the 93 people but I dont know how to reference the 50 Delta Licenses on Adobe Acrobat Pro 8 to the remaining 68 people.
Of course the example I have provided makes it seem not to difficult but you have to remember I have about 60 different versions of Adobe Acrobat, they have multiple editions (Pro, Standard, Corporate, blah blah...) Baisically I cannot see anyway of writing abit of VBA giving each bit of software a Hierachial order in which to refer to.
The best possible way of doing this I can see is creating an alternative table which I will have to manually go through the 23K bits of software and define which bits of software are higher up the foodchain & eligible for a 'Delta License'
Any help is much appreciated!
Cheers
Can someone take a look at the attached prgram and see where my error is:
From the control panel.....Click print invoice....enter 100 and then 1000.......for payment status I want to be able to either pull the "paid" invoices or "unpaid"..........I really dont understand why the tag request comment keeps poping up.......This is a program that I have taken and modified.....Tag rest number I do not beleive needs to be anymore.....
thanks in advance
I have a database of equipment that is hired out. When the equipment is hired out the date is recorded and when it is returned the date is also recorded. That same piece of equipment may then be hired out again. What I want to be able to know is what equipment I still have in stock at the base. I have tried many different attempts of trying to get this to work but I don't seem to be having much success. Could someone please tell me how I can do this.
View 2 Replies View RelatedHello,
I am currently designing a stores management database similar to the Northwind database but alot less complicated. We dont need all stock price,sales price and order information. The objective of my database is to calculate stock on hand and have a alert if current stock levels are below a reorder level.
I have taken a begginers course on access and so far so good. Got my relationships sported and everything is working nicely apart from the stock on hand calculation.
What I have is a products form and inventory movement subform. I have a one to many relationship between the two and when you scroll through the products, the inventory movement is updated too. Great.
But now for the stock on hand calculation. I have inserted a formula into the header of the subform and it works fine, but when I do the same calculation on the form I either get a result that doesnt scroll over with each product or I get a #Error.
I'm stuck and have been working on this for a few weeks, if someone could help that would be great.
Thank you,
Kerry.
PS: see attached for description of relationships
Hi all,
I need a hand from your side with the following.
The attached Excel workbook needs to be transformed into an Access 2003 database.
It is a list of clients’cases represented by lawfirms and the amount of money that is involved.
The case comes in under the ‘Aufstellung’ worksheet and can progress to a Claim or 2 different other Requests.
Purpose of the database :
1.Fast entry of new cases
2.Easy look up of existing cases
3.Conform updating of existing cases (warning when a certain case number already exists)
4.Easy report running
5.Keep the entire history of updates, changes, deletions and processing to a Claim
Tables :
1.Aufstellung
2.Claim Request
3.MB Request
4.MFA Request
-Question 1 : In the tables you will see that several different appointment dates and hours for one case are listed in 1 cell. In order to keep the history of updates do I need to create a separate Appointments table ? How would I structure this then ? The unique identifier is the Case Number. But 5 columns (Columns E, F, G, H and K) are ellegible to be treated this way. Do I need to create 5 separate Appointments tables ? And how do link them ?
-Question 2 : In order to split all the packed Appointments information in one cell I need to transfer the column to Word, replace the manual break by e.g. *, re-import the table in Excel and do text to columns ? So that each Case Number gets a number of columns accordingly to the number lines in the original cell ?
Queries :
1.List all Failed cases per form
2.List all Open cases per form
3.List all Filed cases per form
4.List all New Date set by Authorities per form
5.List all No results per form
6.List all ABC per form
Forms :
1.Aufstellung
2.Claim Request
3.MB Request
4.MFA Request
-Question 1 : How do I set up a check box in the Aufstellung form which, by checking off, will transfer the current record to the Claim Request form ?
-Question 2 : How can I make a field to be a lookup field ? e.g. When typing a name, it will give a drop down list of existing names of the table and the possibility to type a new name which will be stored in the table ?
-Question 3 : How do I make a pop-up warning message in the Austellung form when a certain case number exists already in the database ? And how do I block the case number field for duplicate entries ?
Reports :
1.Aufstellung complete table
2.Claim request complete table
3.MB request complete table
4.MFA request complete table
5.List all Failed cases per Form and include count of Failed cases plus sum of the Main demand in Euro
6.List all Open cases per Form and include count of Failed cases plus sum of the Main demand in Euro
7.List all Filed cases per Form and include count of Failed cases plus sum of the Main demand in Euro
8.List all New Date set by Authorities per Form and include count of Failed cases plus sum of the Main demand in Euro
9.List all No results per Form (empties) and include count of Failed cases plus sum of the Main demand in Euro
10.List all ABC per Form and include count of Failed cases plus sum of the Main demand in Euro
-Question 1 : How do I include a count of the records into the report ?
-Question 2 : How do I include a sum of the Main demand in Euro into the report ?
Switchboard :
1.Make a new entry or update an existing one
a.Aufstellung
b.Claim request
c.MB Request
d.MFA request
2.Search
a.Case Number
b.Applicant’s Name
c.Date
d.Court record Number
3.Reports
a.Failed case
b.Open cases
c.Filed cases
d.New date set by Authorities cases
e.ABC cases
4.History
a.Export history table to Excel through e-mail
b.Who updated the record and when ?
-Question 1 : Do I need to create a switchboard at the very beginning of my database ?
-Question 2 : A switchboard can only contain 8 buttons, how do I create a sub switchboard ?
-Question 3 : How do I set up the user access tracking – who updated what when ?
Thanks in advance !
my details input as per below;
1) table 'Receiving' (Part#,Qty received,date received)
2) table 'Issuance' (Part#,Qty issued, date issued)
How to calculate current stock on-hand?
*previously this report are using ms excel table. i just tried to convert into access since i will have a better view, will a separate form to fill up, will have a report to pull in(hopefully... current on hand )
I have two queries, property info (one) and budgets v spend (many). I'm trying to work out what the gross price is, property cost plus budget or spend (which ever is higher). Got that working no problem.
However if there is no budget or spend I just need to show the property cost but I'm just getting Error#. I've tried using the nz function but that's not working.
Any ideas?
Thanks
I have data which has a one-to-many relationship and I would like to display in a form (or webpage) both the one and the many side of the relationship and to display a count of the number of records on the many side which correspond to each individual record on the one side.
I attach a zipped .mdb file containing dummy data which includes a pair of linked forms showing where I've got to so far with implementing the idea. If the Words form is opened first, the linked form, Associations can be opened by clicking on the Associations button.
(Incidentally, I need to do something to control where and at what size the two forms open on screen. I think I've seen from a post on this forum that what I need is DoCmd.MoveSize.)
The problem I'm hoping someone will help me solve is how to get the count of the records on the many side to appear only once and, preferably in the Words form, not the Associations form. If you view the forms in the attachment, you will see that at the moment the count appears once for each item on the many side in the Associations form.
I'm a beginner and am unsure if the solution is very simple, perhaps involving referencing a hidden control in the Associations form with a path to that control comprising various identifiers joined with ! and or . , or perhaps using a simple snippet of Visual Basic, or whether I'm asking for help with something which is actually difficult.
Hi folks,
I am new to Access programming. I read in some web page on googling that Access is for developing Desktop database. Books inform that Access projects can connect to Server database.
I would like to know if Access can also be use for Server side programming.
- Krish:confused:
Hello,
i am trying to join the results of a many-side of a query into one result field separated by commas...
Table: tblWorkOrderStoresFinal
Row 1: LogNumber: 1StoreNumber: 2
Row 2: LogNumber: 1StoreNumber: 3
Row 3: LogNumber: 1StoreNumber: 4
I would like to make a query that combines the StoreNumber into one field CombineStoreNumbers separated by commas as follows...
LogNumber: 1 CombineStoreNumbers: 2, 3, 4
I tried the following crosstab query, but it's not quite right.
TRANSFORM StoreNumber
SELECT LogNumber
FROM tblWorkOrderStoresFinal
WHERE (((LogNumber)=1))
GROUP BY LogNumber
PIVOT StoreNumber;
Any ideas? Hope this makes sense.
Thanks, Casey
Access 2000
tbl_TESTS (lists all active employees for a company)
tbl_RANDOMS (table that lists which employee needs to take a test)
[EmpSS] is a social security field in both tables to connect them. I need a form that will allow me to show all active employees from tbl_TESTS and then select the option for a test from the tbl_RANDOMS.
tbl_RANDOMS
EmpSS
1Q07
2Q07
3Q07
4Q07
tbl_TESTS
CompName
NameFirst
NameLast
EmpSS
EmpInPool (yes/no check box for active employees)
I want a form that lists all of the fields above.
Show all the active employees
Then if I type something into one of the four fields for tbl_RANDOMS it adds a new record to the table.
I have added a simple DB for an example. When the form opens select Wal-Mart from the drop down. You will see the 8 people they have as current employees. Now it will not allow me to select one of the drop downs for any of the quarterly stats. Thanks.
Hi all,
I am programming a database that contains approximately 3700 records stored in a relational table structure.
When I split the database and moved the tables to the server side, my performance worsened drastically: a query that runs in under 5 seconds when the tables are on the client side takes over 45 seconds in the split database (with tables on the server side).
I've tried a variety of solutions (including changing the subdatasheet name property to [None] in the tables, creating an MDE file from the MDB file), but they haven't helped much.
Any suggestions about how to speed performance are greatly appreciated! Thanks so much!
I have One table(and designed form from it) in which i have recording the daily transactions(it is like a daily book). Daily transactions took place like Purchase of items of Amount 45, sale=70, sold on account=100 etc.
What problem i am facing is: I would like to Add Cash In Hand amount and would like to show it on my form. When day end I would like to move remaining cash In Hand on separate column of that date. The next day i would like to take the previous Remaining Cash in Hand as Cash In Hand at Start for next date and so on.
Hi
In a query I am trying to return all dates (birth dates) within seven days either side of the current date. The properties of the field and the query are set to Medium Date and the criteria I am using in the query is:
Between Date()-7 And Date()+7
and returns nothing.
I have tried several options suggested in other threads without success.
Access 2002 and Australian date format - 14-Sep-07
Any advice would be appreciated.
Tks
Allan