Search results

thanks again Frothingslosh but still i didn't quite get it. i have searched for line by line variable for ms access vba but unfortunately, i didn't catch or find any sample codes. :( This is a sample i got so far: Dim strFilename As String: strFilename = "E:\Data\ACCESS\dom.hbk" Dim...

Yes Cronk I need help on how to do it line by line.:confused:

First off, thank you Frothingslosh for the prompt reply. My purpose in storing it in a text file is like those that I developed in VB.net that whenever they change server, I only replace the text file and not the code. The second purpose is that, we are in a place where DHCP is a common source...

hi again everyone. i didn't post quite a long time. been doing great with ms access 2007. and moving on, i need help on reading text file, line by line and storing them into separate string variables... i have this text file: "E:\Data\Access\connection.dll" and it contains 4 rows: 102.16.21.14...

thanks for the reply Galaxuom!, it was quite an enlightenment. i do use MySQL connecting via 3.5 ODBC driver. it might be frustrating to find difficulties in populating subform. anyhow, the bright side was just in the code was in the condition. i have tried several patterns and got it...

ok, i can seem to analyze how it does worked. i have replaced the microsoft activex data object 2.1 to 6.1 in the references. and here is the trial code: Private Sub Form_Load() Dim myDB As ADODB.Connection Dim rsE As ADODB.Recordset Dim strSQL As String strSQL = "SELECT eid,ename,dp FROM...

thanks JHB, you got my problem. but in my case, still it does not appear to be as intended. it should display 5 rows, but only one row is appearing, the last record(not the first record). i have tried a couple of ways, like, linking the odbc (it does appear), but i prefer not to have a linked...

it did helped a lot during previous year(2013) only regarding the connection string. but, i would like to do a faster way, because if the table is linked, the process of running the front-end (ms access) is very slow (especially to wireless networks) but with just a connection string, it is very...

I have been searching for examples from all searches but i could not find what i was looking for. i found a few regarding continuous form data but its not the sample that fits. attached here is my screen shot and my accdb file (MSAccess 2013) all i need help is how do they populate unbound...

Hi Shaimaa, I found the same problem with my current development. The details are: DELETE * FROM eqpt WHERE eid = '" & me![eid] & "'" DELETE * FROM hist WHERE eid ='" & me![eid] & "'" however I couldn't do it in the current form fEqipment. This is the full code in the command button, hope...

thank you for the clarification. i have revised the code and added the Microsoft ActiveX Object 2.8 to references. I got it. and it saved the file perfectly. thank you very much for the helping hand. This Problem is now solved. here is my revised code: Option Compare Database Option Explicit...

thank you very much GinaWhipp you got my point and i am debugging the codes. i have eliminated the following: saveAsStr = hbkExelPath & ("hist1") & ".xlsx" WB.SaveAs = saveAsStr WB.Close Set WB = Nothing AppExcel.Quit Set appecel = Nothing however adding this: saveAsStr = hbkExelPath &...

ok let me clarify things. the link that GinaWhipp gave me has something to do with basic exporting data. yes it does help. a little by teaching me how to communicate with excel from VBA code in an ms access button. i was looking for a code that already made iin VBA with MSExcel as object...

there is a customized format in excel. that is why i am exporting it to a formatted excel. yes its true that you can do it in msaccess but we are submitting the form in excel format.

thank you for the immediate reply... what i meant with posting data from ms access form, is the specific fields on ms access form into specific cells in ms excel. and to add on that condition, i would like to learn how to paginate the subform datasheet into excel file (e.g. counting first...

basically, i wanted to post a data from an msaccess to ms excel using msaccess 2007 and ms excel 2007. first question is, i wanted to post the main form data into formatted excel and the sub-form data below just like the data appearing from the main form here is the msaccess data: and here...

I got it. I have added the following codes: Private Sub cmdPost_Click() Dim dbASP As DAO.Database Dim rsASP As DAO.Recordset Dim intASP As Integer Dim strASP As String Dim strHBK As String Set dbASP = CurrentDb strASP = "SELECT * FROM tblList;" Set rsASP = dbASP.OpenRecordset(strASP) If...

I have replaced with this code: rsASP.AddNew rsASP.Fields("LastName") = Me![LastName] rsASP.Fields("FirstName") = Me![FirstName] rsASP.Fields("MiddleName") = Me![MiddleName] rsASP.Fields("EmailAddress") = Me![EmailAddress] strHBK = Format(Me![DateOfTrans], "mm/dd/yy")...

strHBK = Format(Me![DateOfTrans], "mm/dd/yy") 'strHBK = Left(strHBK, 2) & "/" & Left(Right(strhkb, 2), 4) & "/" & Right(strHBK, 2) rsASP.Fields(DateOfTrans) = strHBK This line throws the error. but if i replace the rsASP.Fields(DateOfTrans) to rsASP![DateOfTrans] it saves the data...

MS Access 2013 Adding Data Using VBA On_click function. Any help is highly appreciated. Runtime Error '3265' "Item not found in this collection" Produced by the code below (OnClick Function) Option Compare Database Private Sub cmdPost_Click() Dim dbASP As DAO.Database Dim rsASP As...