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?
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)
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?
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.
Using MS 2007, I have a 200 text files exported each day from another application that has two different types of lines (see below). I would like to import each text file in to a database as a single record.
Text file example (text.txt):
R111 WC 8/21/2012 7:00 Doe, John doej 10110110
First Question? Y Second Question? N Third Question? Y ... Seventeenth Question? 10
As you see, I have the first row with multiple fields, but the next rows I have a question and an answer.
I would like to have this data imported as shown in the attachment. Example.zip
Most answers I see are for either multiple lines (same data and sizing). I am not sure how to handle several different lines with that vary in size and delimiters.
I want to print 3 copies of a report named Invoice with different remark i.e. Customer Copy, Office Copy, Auditor Copy. I want to print all 3 copies with a single print command.
Can any one help me. Sample database is in attachmant.
Okay Stupid question, But I have tryed different things and have not got anything to work yet, So I am using Microsoft Acess 2003. I would like to be able to comment out block of code. Thanks Sorry for the stundness...:confused: :confused:
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
Really simple one this one. Though I can't find it in the help or in forums. So simple it doesn't rate a mention apparently.
Except that I would dearly love to know how to comment out SQL code whilst writing queries in Access 2000 SQL view. All that retyping and copy/pasting is causing me RSI.
I have a command button with the VBA code below. I'd like a message box to appear with a comment and an "OK" button that continues the code below . . is this possible?
Private Sub cmdDuplicateOverpayments_Click() On Error GoTo Err_cmdDuplicateOverpayments_Click Dim stDocName As String
Like in excel, when there's a red triangle in the corner of the field which pops up a small comment box, is there a similar functionality in Access that when a field.
Has either a comment associated with it, that a comment box can be made available?
I have a field SSEEndDate. I have some records in which this field is empty. What I would like to do is add a comment to explain why the field is empty on a report if possible. Click on it or move the mouse on it or whatever and the comment would show up.
I am working on a database which will basically serve to be a massive Auditing Checklist. Lots of "Is this done" type yes/no questions to record, some with a comment.
Brief Description: I have many child-forms on a tab-control, each with a different heading/category of things to check for. When someone visits a store, I would like them to record their findings in this form.
In the above example, if the Floors are clean, no input is necessary. If the floors are not clean then the user ticks the checkbox and the text "Floors were not clean" should be automatically entered into the field: Cleanliness 1. The reason for this is that I wish to link the value from this field to a Microsoft Word document using mail merge for reporting purposes, and in the report it needs to state any problems in full sentences.
I have tried using this code in order to update the comment field when the checkbox is ticked, however, the problem with this is that I would have to insert code manually for every single checkbox in my forms, and I have about 150 checkboxes in total.
Code: Private Sub Cleanliness_A1_AfterUpdate() If Cleanliness_A1.Value = -1 Then 'If checkbox is checked Cleanliness_C1.Value = Cleanliness_C1.DefaultValue Cleanliness_C1.Enabled = True Else Cleanliness_C1.Value = "" Cleanliness_C1.Enabled = False End If End Sub
Hi please i have a problem withthis and i need some help, i received some great help so far thank you So much Markoc. and now i'm stucj here.
I have two tables : one called reviews [rid, review] and the comments [cid, rid, review]
the first two pages work fine, but whenever i click on submit on the second page it take me to the third one which cannot be displayed. here is the code on the pages, please if you can help. ------------------------------------------------ on the first page i have " reviews listing " -------------------------------------------------
<% Dim oConn, sConnection Set oConn = Server.CreateObject("ADODB.Connection") sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=xx" & _ "Persist Security Info=False" oConn.Open(sConnection) set rsUsers = Server.CreateObject("ADODB.Recordset") rsUsers.Open "select * from reviews" , oConn %>
<center><table >
<% Do while NOT rsUsers.EOF getrid = rsUsers("rid") getreview = rsUsers("review")
rsUsers.MoveNext Loop rsUsers.Close set rsUsers = Nothing %>
-------------------------------------------------------------------------------------------------------------------------- the second page is viewreview.asp AND ALSO I HAD A TEXT BOX FOR THE USERS TO LEAVE COMMENTS --------------------------------------------------------------------------------------------------------------------------
I have Field "BC1Chng" which requires user input. I want to be able to write a code to reference to "BC1Chng" if there is an input in that field for any record...I want to copy the Remarks into each record in the Remarks Field.
I was able to get the remarks1 field to loop through each record copying what was in that field into each record.
Now I want it to look at the BC1CHng field and only copy to remarks1 field if there is any input in that field???
Is there any way i can increase the amount of columns in a table before importing data? I am importing data from a notepad doc that needs abt 300 columns but i can only get abt 100 columns.
I have created a table in which there is one column of type memo. When I copy the content in this column it is allowing me to enter only 255 characters. How to increase the length of this column type memo?
I have a query with GroupBy. Is it causing me the damage? How to overcome this situation.
I have a table, tblEvents, which I use to store information about a meeting, training session or field trip, including the [StartDate]. I also have a table, tblEventDays, which I use to store the [DayNumber] 1, 2, 3... At the moment I have to enter the day numbers in the subform frmEventDays manually, but I would like to add button controls to increase/decrease the number of days for each event (i.e. add a new record where [DayNumber] is incremented by 1, and delete the last record if I have added too many day records).
I have added button controls to my EventDays subform and managed to use the macro builder to select and duplicate the last [DayNumber] record, but cannot figure out how to increase each successive [DayNumber] by 1.
1. Add a day...
Option Compare Database Private Sub AddDay_Click() ? End Sub
2. Remove a day...
Option Compare Database Private Sub RemoveLastDay_Click() ? End Sub
I have a form with multiple fields on it. We will call them SLO
They are text boxes and there are 6 of them named SLO1, SLO2.....SLO6
What I want to do, is use VB to update each as a string to a table individually. But Id like to only type the code once, and use a DO WHILE and increase the value by one. Example.
Current Code looks like this:
Private Sub UpdateButton_Click() Set rstNewInventoryDataRecord = CurrentDb.OpenRecordset("Select * FROM MetricData") Set CurrentForm = Screen.ActiveForm Dim Counter As Integer Counter = 1 rstNewInventoryDataRecord.AddNew rstNewInventoryDataRecord.SLO = CurrentForm.SLOT1.Caption rstNewInventoryDataRecord.Update MsgBox "Update Complete" End Sub
What I want to do is use the counter to increase by one after each loop and stop after 6. So...Do while Counter < 7
And increase the CurrentForm.SLOT1.Caption by one each time.
Here is my code...if I take out the where statement..it copies the remarks all the way down my table to all the records...with the where statement..it's prompting in for parameters..
Private Sub Remarks1_Click() Dim strMsg As String, strQry As String, strRemark As String strMsg = "Update All Comments in the Current view. IMPORTANT!!! Will update a the Viewed records."
I have a tblCommets that has 2 columns in it. The first is an identifier (1,2,3) and the second column is a comment associated with that identifier. Is it possible to use a query to pull that comment based on a user selection? So, if the user selects 1 then the comment associated with 1 is pulled, but if the user selects 2 then that comment results.
I have a comment box that was just for text. I have been asked to adapt this to allow a web URL to be typed in which would then become a clickable hyperlink (like typing in a Word document). Is this possible?
