Question:
In this database, in the form “Child Information” I wrote SQL code to add all the data in the unbound fields into the table. In particular I am concerned about ensuring that birth date information is entered in a single format (MDY). When I press the button which runs the VBA code, I get the [...]
Question:
I have two Access Tables.
Table 1: contains an identifier and a value, call it B(0,k), where k in [1,n], n = # of recordsets
Table 2: contains a set of fields:
1. identifier: i(k), where k runs over n.
2. dates: D(i(k), t), where i is fixed identifier, t ranges over a time period [0, T]
3. value1: v1(i(k), [...]
Question:
How can I assign multiple passwords to a userform. Instead of having to create a “Password Window” userform each time I ask for a password, I just want to use one “Password Window” and be able to assign multiple passwords to it.
Code Snippet:
‘Code in a specific Worksheet for Approve Button
Sub Approve()
Call PasswordBox ‘ I would [...]
Question:
I have a form containing 10 Checkboxes with lables. Each lable contains a query name. The user will select the queries they want to run by checking the checkbox next to the lable.
Currently, I am using 10 IF statements to find out which checkboxes the user has checked.
How can I use an Array or Collection [...]
Question:
I am trying to export data into a txt file where each activity performed on each day gets a record, while the data is stored in Access where all the days with that activity are listed in the same record. Let me show an example:
The way the data is stored in my table is as [...]
Question:
This is pretty straightforwrd I guess. DJ4 has a hyperlink to the workbook whose FullName it contains, if that is of any relevance.
Thanks,
John
Solution:
third time pays for all
[DJ4].hyperlinks(1).follow
Thomas
Question:
I recieve a spreadsheet from France, Russia, and Saudi Arabia separately. The description field always contains the English and the Non-English verbage separated by numerous spaces, return characters and or special characters. Sometimes the Non-English verbage is first sometimes the English verbage is first. The length of each is also variable.
I need to remove the [...]
Question:
Can I get the tables from several web pages and put them into separate worksheets?
for example:
table in “http://www.cuhk.edu.hk/bursary/eng/public/payroll_benefits/mpf/investment_performance/ipme0701.html#Menu=ChildMenu8″ is copied to sheet 1 and
table in “http://www.cuhk.edu.hk/bursary/eng/public/payroll_benefits/mpf/investment_performance/ipme0702.html#Menu=ChildMenu8″ is copied to sheet 2
The number in the link , 0701,0702, represents the year and month and I want to get all the data from 2007 Jan to now. [...]
Question:
Hello,
Please see the attached Excel file. Using VB code, I want to be split each string in column ‘A’ into 2 separate strings. The seperator for the two strings could be the ‘>’ symbol. Any idea how to impliment this?
Thanks,
mvem
Solution:
Sub splitA()
On Error Resume Next
Dim index As Long
Dim tempArray() As String
With ActiveSheet.UsedRange.Columns(1)
For index = 1 To [...]
Question:
Hi Experts,
I am trying to find a way to import Excel or Text files into access but giving the user the option to import the files from any location like the open file dialog box. I looked for it in this forum and found few of them but nothing has worked for me. Note, i [...]