|
Compare Records & Move to new table in VBA
I want to make a loop whereby i can compare the first record with every other
record until i find a 'True' comparison, if i find this, move the records
into a new table, otherwise, move onto the second record and repeat.
I figured i would do this with a for next loop, i have done them in excel,
but im not certain of how to compare cells in access.
Thanks
Tom...
|
1 |
12/2/2008 9:12:01 AM |
|
|
export to Excel
I have set up a number of macros to export files to Excel. The files are
meant to overwrite the previous file. I can't find a way to get around
having to click OK to the pop-up regarding overwriting the existing file. Is
there a command that will do that for me?...
|
2 |
12/2/2008 3:59:30 AM |
|
|
Autorun Macro needs to run every 10 seconds 24/7
Hello, I have searched the forums and found similar topics but none so far
answers my problem which I hope someone will.
I have an AutoExec Macro which needs to run every 10 seconds 24/7. I have
achieved this by setting Start up to open a "FORM" and on Event tab set "On
Timer" equals AutoExec Macro and "Time inverval to 10000 ms.
This works well until next morning the Database locks up a...
|
2 |
12/2/2008 12:41:26 AM |
|
|
Convert macro to VB
How I can use or run the VB code after converted from macro...
|
2 |
12/1/2008 7:48:01 PM |
|
|
Transfer Text to CSV file
How can I get a .csv file using transfer text?...
|
12 |
12/1/2008 11:59:01 AM |
|
|
transferspreadsheet or output action
Is there a way to write to a specific excel cell (ie F19), with the
transferspreadsheet or output actions? I am also trying to do this
programatically?
Help! Everything just goes to the first columns and rows. I am going crazy......
|
2 |
11/30/2008 2:04:23 PM |
|
|
Autofilling and clearing info in form using Check Box & Macro?
I'm using Access 2007. I have a Customer Table and a Billing Table and have
created Forms for each. When I have a particular Customer displayed in the
Customer Form and need to set up Billing Info, I have a Checkbox, or Toggle,
or Button (have tried all 3) on the Billing Info Table where if it is clicked
will fill in the info from Customer Form. If clicked again, it should empty
the Form...
|
4 |
11/27/2008 3:00:45 AM |
|
|
Macro Commands\Values help
I am trying to build a macro that will be used with a button on a form that
when clicked it will checkoff on a checkbox field named Comp_Rev within the
table, save the record and then advance it to the next record.
I have tried a number commands but i cannot find anything that gives the
command of checking off a box in the specific field on the table.
I appreciate any help, thanks in...
|
6 |
11/26/2008 8:48:40 PM |
|
|
MACRO Alerts and Access 2003
Is there any possible way with which we can disable Macro alerts that user
get while they are using Access 2003 with office 2007 installed (w/o Access
2007)
...
|
4 |
11/25/2008 10:19:33 PM |
|
|
filter and export to excel
i have a table in access with appx 1 million rows of data. there is an
identification field in that table that has approximately 500 unique values.
what i would like to do is create a macro that would automatically export the
data associated with each of those 500 identifiers into their own tab in
excel where the macro automatically creates a tab for each of the values (so
i can avoid ...
|
5 |
11/23/2008 3:49:59 PM |
|
|
Filtering drop down selection
I have table 'Bed Status' with lookup fields for field 'Division' & 'Unit'
from table 'DivisionUnitBedCapacity'
Division has 5 choices and units belong to on of these five.
Trying to filter the unit choices by the division that the end user chooses?
I can't seem to get the filter to work any solutions?...
|
9 |
11/21/2008 10:56:35 PM |
|
|
Use the Current Time as a condition
I would like to use a Micro to back up my data when the program is closed.
However I only want the back up to run only if the current time is after 6pm.
How do I phrase my condition?...
|
2 |
11/21/2008 6:37:01 PM |
|
|
Sort Subform by ComboBox Help Please?
Good day, I am trying to sort a subform based on a combo Box afterUpdate Event.
Details......
Main Form Name = frmSearch (Combo Box Name = ComboAlloy)
Subform Name =SubfrmSearch (Underlying Query Name = qrySearch
Macro Name = Filters:Alloy
Apply FIlter = qrySearch
Where Condition
[tblQuoteHeaderSub.AlloyType]=[Forms]![frmSearch]![ComboAlloy]
However it isnt working..Can someone h...
|
2 |
11/21/2008 6:13:06 PM |
|
|
Trying to set a tempvar in macro on double click event
Hi,
I am having a hard time getting a macro to do what I need it to do. I have
learned how to open a form set to a certain record when double clicking on a
report. I use the double click event to fire a macro that opens the form with
the WHERE section set to ="[customer] = """ & [customer] & """" and it works
without any problems. However, the DB has poor design and I didn't use key
v...
|
1 |
11/20/2008 6:18:04 PM |
|
|
Delete Object
I recently converted several Access programs to the newest version (2007).
However, I cannot 'see' the prompt for deleting a table when I try to write a
macro. I have gone to the trust center and done what I need to do there. Any
other ideas??...
|
2 |
11/18/2008 7:18:10 PM |
|
|
How to Link to an Excel File By Prompting the User for the FileNam
I have an Excel spreadsheet that is updated weekly. Weekly, new records are
added to the file that need to be compared to a data file in Access. Since
the file is changed weekly, I want to prompt the user to provide the file
name that needs to be linked to the Access database so that the queries and
assessments can be performed. But, I don't know how to write code to prompt
for this i...
|
5 |
11/18/2008 4:15:31 AM |
|
|
Encrypt Report sent by Macro action
I have a Macro with a SendObject action that sends an Access report in a
Microsoft Excel 97-2003 output format. Is there a way I can have the
generated Excel Workbook secured such that the sender cannot open and read?
The data resides in an Access Table and I am not sure how to encrypt the
report such that only the receiver can open and read.
Can someone help with this? Thanks.
Zikar...
|
1 |
11/17/2008 1:27:01 AM |
|
|
How do I create a macro to type repetitive entries?
When I am entering data in a database there are many times I have to type the
same entry, such as a city or zip code. How do I create a macro to do that?...
|
6 |
11/16/2008 4:10:30 PM |
|
|
Hide a Column
Is there a way in VBA to hide table columns?...
|
3 |
11/16/2008 2:58:02 PM |
|
|
Select specific text from field in query
I need to query or filter on a field that has various characters and I am
unsure how to do this. I am not skilled in VBA so i am trying to use the
criteria builder in Access on that field. Here is what I am trying to do.
The data in the fields look something like this:
FIELD1
22N 3 33N
4 5 22N
3
3N
4 3
5 4N
I need to query records that have a "3". The three could be in any
p...
|
6 |
11/14/2008 5:22:02 PM |
|
|
Problems with edithyperlink macro action
I use Access 2007. I have created a macro to enable users to hyperlink files
to their newly created records. The user clicks on the default link, which
contains the full path to the server. The macro open the edit hyperlink
window, with the default location, already selected, and then the user clicks
on browse for file to go and select his/her file.
I am aware that there are lots of discu...
|
9 |
11/13/2008 10:35:34 PM |
|
|
Populate a field on a subform from data in a pop-up modal form
My main form contains a subform (one to many relationship). When user
completes the main form, they click on a button which opens a pop-up modal
form requesting information. When user clicks OK, I'm trying to get a value
from the modal form to copy to a field on the subform.
I put a OnClick macro on the OK button and an OnMouse down function to set
the value to the subform field b...
|
5 |
11/13/2008 8:19:00 PM |
|
|
floundering - help with generating territory data
I am having difficulty with MS Access and I am not sure how to go about
getting assistance. At this point I have considered just hiring someone
locally to do this work but ultimately I just need the quickest solution so
I thought I would post to see if it was somehow easily explainable (and I
really don't know anyone who specializes in this anyway). I do not know VBA
but I think I can ...
|
3 |
11/12/2008 5:56:10 PM |
|
|
Macro for specific number of characters in a cell
Hello! I have a list of account numbers (some of which include letters) and
most of them currently have 3-5 characters in the cell. However, I need for
each cell to have 9 characters. Thus, I need to have zeros before the
account numbers in order to make the cell have 9 characters.
ex: currently the account number is 358rg - but I need it to be 0000358rg
Can someone help me create ...
|
2 |
11/12/2008 5:52:01 PM |
|
|
??????
zugeerspam@yahoo.com
...
|
1 |
11/12/2008 4:16:32 PM |