Search results

G'd Afternoon Jera, I'm not aware if that's possible, but a workaround could be to duplicate all your textboxes and "hide" the bounded ones showing just the unbounded. At the button click you will need to copy each unbounded to the bounded. There may be many other ways but this one seems easy to...

G'd Afternoon daievans, to get the file properties you need a refeence to the File Scripint Object Library (FSO) then you can do something like this Private Function FileDate(strFilePath as String) As String On Error GoTo ErrHandler Dim fso As FileSystemObject Dim oFile As File...

G'd Afternoon, Use almost any date function to compare the current date with user's date something like this Private Sub txtWorkDate_BeforeUpdate(Cancel As Integer) On Error GoTo ExceptionHandler If VBA.DateDiff("d", VBA.Now, VBA.CDate(Me.txtWorkDate)) <= 0 Then MsgBox "Just...

G'd Afternoon Tim, I don't use DAO at all, i'm not any help there, but i'm wondering why do you have a clone of a combobox source? For what i see in your code all what you need from the combobox is the current selected item. Why to waste memory with a recordset? Wouldn't be easier...

G'd Afternoon Mafhobb, The Regex library will do that for you. This is the way i do it Private Const mPattern As String = "^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$" Public Function IsValidMail(strEAddress As String)...

G'd afternoon Kvar, I don't know if this will help but, what about build a biiiiiiiig array, filling it with your 2/3 queries. The idea is to use an array to transfer (row by row) all the info to Excel worksheet. I don't need to tell you that to do this you can't do it with the DoCmd. Excel...

G'd evening all, I'm sorry Mari, i'm just in the night-morning shift :( . But you can't be in better hands :) . People assisting you is top class.

Hawkins, Brian is right you can't use an alias in a group by. That's why the Error. Thanks Brian for the point :)

G'd afternoon Gary, If i got i right you want to convert z:\share\folder\file.ext to \\server\share\folder\file.ext right? If so. You can get that info from the Windows registry. Usually that info is stored in HKEY_CURRENT_USER\Network. Knowing that and some string manipulation you can get the...

G'd afternoon Chris, I guess you may want to read this. Looks to me that if is possible is not gonna be easy... G'd luck

G'd afternoon, You can add almost anything to the body's message. You can even create the email for "individuals" and send it as attachment to the leader. G'd luck

G'd Afternoon Hawkins, You don need the Group by unless you need to count/sum/etc. This is enough SELECT Month &"-"& Year AS Concat FROM New_Raw_Data

It might be safe to remove that row source. g'd luck

Carly, What we all are trying to say is that you need to give a copy of your access file for each on of your users. No need to change a single line of code. As Pat said, Best practice is to give each user a copy of the adp/ade file so they have their own. G'd luck

G'd afternoon azhar and welcome to the forums! We're here to help people to solve specific problems, please don't get me wrong i don't want to be rude, but we can't do your homework. Please show some of what you have done for your project and address an specific issue, then we can start from there.

g'd afternoon, If you get results from that tbl/qry is because exist, but is probably hidden. You don't say which is your access version, but look for the navigation pane options and mark the "Show hidden Objects" option. That should work. G'd Luck

You just have run that code once. Create a new module, place your code there, hit F5 and that should do the job G'd luck

Like the post said: Open your form(s) form's properties-->Other-->shortcut menu bar. There should appear your "CopyandsortShortcutmenu" G'd luck

G'd Afternoon Steve, Seems like your link is no longer available....

G'd Afternoon, In my opinion, unless you have reasons to get the 2k13 version, you may want to keep your 2k7 or move to 2k10. The 2k13 is more web integrated as for desktop almost the same. G'd luck