Search results

Thanks for the backup tips guys! LOL @ ridders Confucius quote :)

Guys, original post states that I had a backup, just lost some VBA code written since the last backup. Ridders, I'm gunna keep dancing and coninue my sword training. I've put it all back together, and added a couple of tables and queries back from the database produced by the code I executed...

Well I ran this code and compacted the database to 120,000kb but the forms and all VBA modules are gone.. any tips? Private Sub Command0_Click() On Error GoTo errHandler Dim oFSO As Object Dim strDestination As String Dim strSource As String 'Get the source of your back...

Thanks for the response ridders 1. Can you open it if you hold down the shift key to bypass any startup code No, says database is corrupt or not recognized 2. Can 64-bit Access handle files larger than the 2GB limit for 32-bit? I know that's the case for Excel but not sure about Access? Yes...

Hi, I have an access database which is used to run a procedure and extract and manipulate large datasets for a linked SQL Server table and spit out excel files for my work. It runs overnight, and last run bloated to a file size of 2,097,063kb. Now I cannot open to compact and repair as I get a...

.mdb = 2003 or prior, so you just click on the macros objects in the database window then select the macro and click design. If you are using 2007 then: The left side of database window has a 'Navigation Pane'. Click on the >> at the top to open. Click on the downward arrow to view other...

Why did you mention Warney? He retired years ago :D

Michael Clarke v Alistair Cook --> most runs? The Aussie Bowling attack will be primed come June July. The poms won't know what hit them. Time for another bodyline series...bit of chin music will make the poms turn to water.

My tips are: In Engerland (: ) Aus wins series 2-1 (2 draws) In Australia - Aus wins 5 - 0 It will be good!:)

try this code...or similar a = MsgBox("To save or not to save", vbYesNo, "SPENTY") If a = 7 Then 'clicked no DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 Else DoCmd.DoMenuItem...

Forms![Formname].requery If the form is already open you may have to include this in your code (it may be already there...didn't have time to check it)

The checkboxes are unbound, so what is the filter going to refer to? You have to filter by something in the query/table that the report is based on.

Well done my Liege

I dont have access 2007 here, but from what you said to get the text from the combobox try using comboboxname.coloumn(0) or comboboxname.coloumn(1) etc... depending on which column has the text. The execute button (is there a onclick procedure?) Finally they are not VBA "scripts" they are...

Greetings and salutations, You need to provide more information on how the address data is stored (e.g. table names and what data is in those tables) also how you have created you query etc.. Describe your database and how it works. Thanks, Spent

'Greeting. 'Firstly get the counter value Set objApp = CreateObject("Excel.Application") objApp.Visible = False Set wb = objApp.Workbooks.Open("fileHere.xls", True, False) Counter = wb.Sheets(1).Rows(1).value wb.quit ' or whatever you use to c lose excel..my brain hurts today so look it up...

Use this. Replace the names and subject and attahcment etc with your rdSet(<field>) values Sub SendMessage(DisplayMsg As Boolean, Optional AttachmentPath) Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Dim objOutlookRecip As...

GREETING.... Dim Msg As Outlook.MailItem Dim MsgAttachments As Outlook.Attachments If IsMail(Item) Then Set Msg = Item Else Exit Sub End If Set MsgAttachments = Msg.Attachments MsgAttachments.Add rdSet(<fieldname>).value 'add recipients etc End Sub Function IsMail(ByVal itm...

Yo man, You can use DSUM to get a cume tote. CHeck the form. Go to the end record and add a new one and watch the cume tote change.

Not sure if you have to, for some reason I have always done it (maybe years ago I found a need to do it? Let me test this out dude.....*alters VBA in searchy.mdb*.......it appears that you don't have to. WTF, why have I always done that? Perhaps it is because I am a spent geezer?