I have a main form with a few imbedded sub forms.
Sometimes these is a great deal of data in one of the sub forms & non in the others.
Is there a way that the sub forms can grow depending on the amount of data there is in each particular sub form. (The sub form grows for a lot of data & shrinks for little data)
The way I have it now is that each sub form is always the same size and a scroll bar appears when these is extra data. This is OK but I need to see all data in sub forms at once if possible.
Can anyone help with ideas please?
I have now a report that span around 2 pages. It has subreports in the report that depening how many rows there are they can grow or shrink.I have the problem that the second page the top margin is to close to the top of the pager. The paper has a logo on the right top side. I can make the first page look nice under the logo, but the second page prints to close to the edge that prints over the logo. I did add a page break, but when the page 1 has more data, it flushes this to the next page. The page 2 is now page 3. How can I avoid that, or make it so that the margin of the second page/next page is on the correct lenght of the top. I tried it with the page setup, but it does not work.
Do you guys think the database will get small in size if i have like 200 records and each one of them have a 4 kb thumbnail as OLE object?
I know that putting big images in OLE objects gets very big but a small thumbnail is ok and doesn't increase the size of the .mdb so much? (130x98 pixels)
Can someone tell me that more remark / comment lines in VBA might be one of the reason of increasing the db size?
Because now a days I am removing the queries from my db and started to use VBA code lines behind each forms and keeping some remark / comment lines to know what a particular set of code line means and what they are doing. So I put everywhere some remarks / comments line. Now my forms are faster than before but the over all size of db become heavy.
Are comment lines one of the reason in increasing db size?
It has been a month and I'm still 'stuck' on my Microsoft Access lessons due to a peculiar error. I have a video of the error, but it won't let me post a link until I have 10 posts. When I create an action button and then scroll at all, the button jumps in size 50% to the right and down, but this extra space can't be edited. Clicking on the 'extra space' is like clicking the background.
I have tried
1. Reinstalling Office 365 2. Reinstalling my graphics card drivers (Using a GTX 560ti SLIx2) 3. Manually entering the size for the buttons in the button properties (still increases in size)
I have a project where the schedule calls for a web-enabled database for 100+ users to merge five separate systems into one. If I can't get past this problem, I can't continue my lessons.
I have a report that prints labels (similar to avery labels) which pulls data from a query. These labels are all unique and vary in length. Due to the length variance, I want the font size to get smaller for labels with more characters. I want the text to go down to another line when necessary.
In my report under the OnPage Event Procedure I wrote this:
Private Sub Report_Page() If Len(Text2) > 20 Then Text2.FontSize = 8 If Len(Text2) > 10 And Len(Text2) < 21 Then Text2.FontSize = 10 If Len(Text2) < 11 Then Text2.FontSize = 14 End Sub
This works to some degree but the problem is that once there is a longer label, all of the proceeding labels are resized & the longer label that should have been resized was not.
Is there another place I should be writing this code? I looked under events for the textbox but there doesn't seem to be anything that would work since none of them would trigger when printing labels
i have a standard database with tblProducts, order, employees, customers, suppliers etc. i also have a table called tblperson with personID which acts as a one, with the many in three different tables (customers, suppliers and employee) the person table holds data such as first name last name address city postcode and phone. now, ive created a form called frmPerson that acts as a adding data to my database. ive got a load of buttons a working add, delete and a save button, i also have the option to switch through records next, last, end and first. now basically in this form i want to be able to add data i.e. fill out the text boxes and then have a combo box or something similiar that when i add the data i can basically click an option the says 'employee' 'supplier' or 'customer' and then the data gets added to my person table however the difference is that it will also be associated to the record in the wanted table.
I have a two level security system to protect my date. The first uses the MS Access security, the second is a simple login system wherby a user enters their name and personal password to gain a customised view of the data eg if the user is me, I can see all tool bars, other users cannot. What I would like to be able to do is write a query wherby I can use the users login details to diplay only their data. An example of the script I built is as follows
'IF USERNAME AND PASSWORDS CORRECT THEN LOGIN TO THE MAIN SWITCHBOARD
If Me.qpwd.Value = DLookup("PWD", "AUTHORISED", "USERID = '" & Me.quserid.Value & " '") Or UCase$(Me.qpwd.Value) = "abcd" Then DoCmd.Close DoCmd.OpenForm "Course Booking System" Else MsgBox "Invalid Password" End If
Is there a way of including a select criteria like the following
SELECT USERID, DETAIL FROM COURSE WHERE USERID="Me.qpwd.Value"
I have tried several differnet versions for this syntax without success!
I have a data field (status) that is either Graduated, Terminated, or Current. I also have a report that has a check box representing each (such as a check box for graduated and another for Terminated etc).
I am trying to get the report to read the status and check the appropriate box in the report.
I have tried this in the control source of the checkbox =IIf([status]="terminated";True;False) but this does not work
I have also tried this on the OnOpen
If [status] = "terminated" then termcheck = true else termcheck = false end if end sub
But this does not work either - what am I doing wrong :confused:
I have a form (Access 2010) that we use to keep track of client data. When I enter a number equal to 6 or above in one field (Client Rating and this field is actually formatted as text because it could be 6 or 6a, b, c or 7 or 7a, b, c, etc), I want anything =>6 to automatically check a box in another field which is the Watch Indicator box (a yes/no box), how would I do this?
I tried to create an expression like the below on the Watch Indicator check box and it does not work - not sure why - it did not say it was incorrect, I think I may have it in the wrong place?
I am trying to project how long it will take to reach the 2GB Access limit in a specific project.
My client downloads approx 250,000 records on a monthly basis. I've been provided w/ a sample Excel spreadsheet. I filled a spreadsheet w/ the max number of rows (65536 rows w/ 10 columns of data), and imported that into a new table in a new .mdb file. I copied the table 4 times, so I now have 4 tables of 65536 records each. Compacted before closing. Size was about 52MB. Assuming consistency, I calculate that the size limit would be reached in about 36 months.
262,000 records = 52 MB. 52 MB a month x 36 months = 1,872,000 MB.
I have been creating a personal database (access 2002) to keep help keep track of all the stupid things I own. I was wondering what people think about encoding data to help reduce database size. I know that for my small database it probably doesnt matter, but it it worth it to enocde colors into a couple of characters (2) instead of having a text entry that could fit a color spelled out (15). Ex.
Gray vs. G Dark Gray vs. DG Black vs. B Blue vs. BL etc.
I have come across a number of times when I can encode data and then write code for my forms to interperet that data back to plain english for me. Am I just wasting time if I do this? Or is there a point where this is recommended? Thanks for your advice.
Will keeping your field size shorter result in a smaller MDB file?
Or does Access only use as much space as there is real data in its fields.
Way back in the dBASE III days, dBASE would pad all your "real" information with as many spaces as necessary to fill up your field. I suspect that the MDB structure is probably smarter than that.
Another question on the same topic - I believe there is a maximum number of characters in a record (4000?). Can your field sizes add up to more than 4000, as long as the actual data, all combined, never totals 4000...? Thanks............ ..dc
Firstly I would like to state that i have very little knowledge of Access databases (my job is not computer related) but I am trying my best to get a few issues sorted... So here it goes: I have 2 tables, one large table with about 3-4000 rows(horizontal lines), and a smaller table with only about 1000 rows.
The rows in the big table contain Products (name, dates, adresses, phone numbers etc) and every product has a 'Codename' in a column-line (vertical) of the big table. (there are about 3000-4000 products) In the small table there exists a similar column-line (vertical) that contains 'Codenames' of the Products listed in the big table, but there are only ~ 1000 'Codenames' not the full 4000 ! The reason for this is that in the small table there exists another column-line(vertical) that for every code listed (in the small table) contains a certain specific "description".
My task is to get all the 1000 "descriptions" from the small table inserted into the Big table accordingly to their proper 'Codename'. This means createing a new column in the big table and: if the codename exists in small-table insert the description in the new column-cell, if the codename doesnt exist in small-table leave new-cell empty...
How do i do this ? :) Im guessing some coding is envolved.. and i have no clue whatsoever.... Thank you, George P.
I'm having a problem with mdb file size. I'm importing a large amount of data from a number of tab delimited text files via a simple transfertext function. The process goes: empty the tables in the database, then import the data into the tables.
All this works fine, but the file size rockets to over 1.5Gb. When I then compact and repair, it goes down to 420Mb. I'm not deleting and recreating the tables, and at no point is there 1.5Gb worth of real data, so what's causing this?
N.B. I realise I can call compact and repair following the import, but this is going to take too long as they are user-initiated imports.
I have a form, with 2 Combo Box's and a List Box. The Combo Box's provide a search criteria and the results are displayed in the list box [searchList].
I want to be able to double click a record in this List box [searchList] and that will open a from [frm_SearchDisplay] with the selected record from that List Box [searchList]
Can someone please point me in the right direction.
I have four forms (each form 'relates' to one of the 'Yes/No' fields) and contains additioanl information to be completed.
When I create a new record in my database I tick one, two three or all four of the 'Yes/No' fields.
I would like some VBA code that will automatically open the relevant form (depending on wether the 'Yes/No' box has been ticked) when I click a button.
