@zmbd and guy:
oh sorry, recently I code a lot on Excel vba so I forgot macro/vbaCode aren't the same thing in Access :D
Macro Script in Access is an built in function that lets user do some simple task, it sometime helpful but usually not really flexible (compare to vba code).
when I mean something wrong, I mean he doing some thing wrong, not the information he provided wrong.
Ok, that's my fault to comment...
hvsummer
Last Activity: Aug 5 '16, 09:35 AM
Joined: Aug 14 '15
Location:
-
can you tell us more detail about
what do you mean code builder ? what do you mean macro builder ?
for me, those code/macro are the same thing == so I know something wrong here..
What are you planing to do ? please tell me the purpose, not your previous action...
I could suggest and give you some example if you've given the clean picture....Leave a comment:
-
@RAM022:
welcome to bytes.com
you can select your report from a query (rowsource of combobox) which sql like this:
if you don't need to automaton a list of email address and your signature prepaired on email, just do as zmbd's suggestion.Code:SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND (MSysObjects.Type)= -32764 ORDER BY MSysObjects.Name
but if you need to...Leave a comment:
-
I suggest you not to use attachment field of Access to do this.
better way, I think you can organize those document into a folder, then use Excel to store name/ID and hyperlink of those document so that your team can access to those file.
but I have to ask, your team is in the same local network or they're using internet ?
do you have any file server to store those file ? (you can google drive as an altenative)...Leave a comment:
-
@iraidotel:
for import/Link excel file, you can use this function
MultiImportExce l
it has debug info and option to import/link excel into access.Leave a comment:
-
that 2 reason are right, I want to add database function to excel which will or will not treat excel as database (excel can be front end if connect to hidden database or backend with table is a range)
the power pivot is not friendly, and multitable pivot is not the choice, pivot can't do as much as query, not flexible.
and I did post and SQL function to insight section of access, so that'll be simple enuf for you to understand...Leave a comment:
-
Thank everyone for the reply,
my goal is creating new tool that similar to power pivot,
I'll create new function base on SQL, with some new form to create query and bring all the SQL-database to excel
then everyone can use excel as a SQL-database without using access, the performance will surely increase as SQL work faster than Vlookup/index or any searching/match method of currently function.
ultimate,...Leave a comment:
-
Open Spreadsheet as modal Datasheet form in Excel, is it possible ?
Hi guy,
Datasheet form in Access is very good function, I can do the same thing in Excel by
...Code:Sheets(i).Usedrange.copy Set NewBook = Workbooks.Add(xlWBATWorksheet) With NewBook .Sheets(1).Range("A1").PasteSpecial xlPasteValues, , True, False .Sheets(1).Range("A1").PasteSpecial xlPasteFormats, , False, False End With 'some code to save data when close new w -
@neoPa: that not what I mention, I understand your idea about .defaultvalue.
but controls.Value look like that too ? I mean that rule may be apply to .DefaultValue, but It won't apply to .Value, right ?
because manytime since I use .Value property with text, I don't have to " = chr(34) & "ABC" & chr(34)" ==Leave a comment:
-
@zmbd:
when I read this, I tho that everyone could know that he need to synchronize record between 2 form.
we can say he need to make sure 2 record that currently show up in form is the same.
there are 2 problem could occur here:
First, if he only want to make sure 2 form have same filter, same order, same currently row.
Solution for this is make a form with subform, link 2 form...Leave a comment:
-
I think we can call
if that problem come from filterCode:somevar = Forms!FormName.filter Me.filter = Somevar
but I think you should create new recordset from your query SQL then bind recordset to those 2 form as NeoPa suggestionLeave a comment:
-
me too, I'm going to edit my comment :3
and btw, NeoPa make me confusing about .value property = text string like "MA" in vba is valid,
because access know controls.value = "MA" equal value MA text data type, if we add "MA" mean value actually "MA" not MA, then
state will become ("AL", "AR", "AZ",...., "AM", ..., "WV", "WY")...Leave a comment:
-
you can use vba to set default value for controls
and can trap condition to make sure if controls.value = "" then controls.value = "MA" like thisCode:.DefaultValue = Chr(34) & "MA" & Chr(34) 'Chr(34) is double quote
...Code:if me.dirty then if controls.value = "" or isMissing(Controls.value) then controls.value = "MA" me.dirty = false end if
Leave a comment:
-
@Kerrymct478: welcome to bytes.com
the first thing I have to tell you that you can't get value represent for "left a check box" from a different form.
When that "different form" closed, everything unload, even controls.value, even these forms are connected, only available when they 're form and subform (open together then that not problem).
to cheat this problem, you can temporary save checkbox.value...Leave a comment:
-
that RmDIR() similar to DOS command that supprising me ==
didn't know some command like that still valid :D
even the FileDateTime()
and GetAttr()
we can even upgrade code to make it delete or not delete the hidden sub folder :D
it's not really I concern too much, actually I'm interesting in making new code to solve new problem, and will be happy to see new code born by anyone :D I like creative ;)Leave a comment:
-
@Hishow: can you post your currently code ?
and btw, what error and why you can't get your dream results ?
please give us more detail, we can help you to solve that (most of case, we can solve all problem without limit except limit from hardware or software itself)Leave a comment:
-
I think rondebruin have better example here in this link
Delete files and folders
this code copy from that link that clear everything in main folder without condition >=30 days
...Code:Sub Clear_All_Files_And_SubFolders_In_Folder() 'Delete all files and subfolders 'Be sure that no file is open in the folder Dim FSO As Object Dim MyPath As String Set FSO = CreateObject("scripting.filesystemobject")Leave a comment:
-
@zmbd: I'm sorry if my move affect you guy.
Sometime people don't wanna follow the link, or even follow the link but don't know where to start.
it take too much time to know what happen and received information not worth the effort. (like me)
sothat, with my little knowledge, I try to explain what I know, may be he will get it.Leave a comment:
-
@Hishow:
welcome to Bytes.com
you can't call for the directly code as solution.
we come here to ask how to do that -- not how you guy do that ==
to delete folders in vba you can use:
to rename or move folder/files you can useCode:kill "fullpathhere"
if the second name is different from first one, file/folder will rename...Code:Name firstPathName SecondPathName
Leave a comment:
-
last time I deal with navigation button it confuse my head a lot haha
@sachuchem22:
first you has to name your navigation correctly.
next, if you use 2D navigation, you have to remember in mind, the sub-navigation is not really sub-navigation.
it just under that group, but still have navigation button name.
if you use 1D navigation, everything will ezier.
first thing you have to do to determind what...Leave a comment:
No activity results to display
Leave a comment: