Search results

Thanks for reply. Yes, I've made that query already. That is not an issue. Not sure how to go from there? Table Orders is main table of course, and customers table has relationship to it. Now how to make (new table or string) to have dates lined up one next to other divided by (,) in...

I want to have different dates appear in column next to customer. I have lot of customers which items arriving on different days. So now I'd like to have them organized in a way that in one column (or string) there is customer’s name and in next dates when items arrived divided by (,)...

I've been trying to make this work, and finally I got it. Thanx for help!

Here is what I want to do; I want to change value of checkbox [Zavrseno] from false to true by selecting records in Listbox [tablica] in query [isporuka po policama] I've assigned this code on command button: Private Sub Izdano_Click() Dim rs As DAO.Recordset Dim ctl As Control Dim varItm...

Thanks... It didn't make accde - only overwrites accdb without prompt. I have main accdb on server and want to save accde there also. Any clue? P.S. There was no error in process. I just put "ConvertToaccDE" as code on a button.

THNX, but... 1st link takes me to post reply?! - That's no good. Next, I already tried this code but it gives me error on "msoAutomationSecurityLow" that object is not recognized... Any new ideas?

Is there a way to progammatically convert ACCDB into ACCDE file format? Can someone provide a code to do it?

Yes it is. Clearly this code is missing something...

Teis is what it does: Public Sub BackUpAndCompactFE() Dim oFSO As Object Dim strDestination As String strDestination = Me.path2backup & Me.FileName & ".accdb" '<-You will have set to the name you want!! 'Flush the cache of the current database DBEngine.Idle...

So, my code does not loop through records - it backs up just the first file... Here is my code - - - - - - - - - - - - - - - - - - - - Private Sub backup_Click() Dim rs As Recordset Dim strSql As String strSql = "SELECT * FROM files;" Set rs = DBEngine(0)(0).OpenRecordset(strSql)...

Unfortunately, I'm not allowed to change or modify Outlook or any other software, and especially to install third party software... THNX

Thnx Btw, I found solution. And yes I have been using sendobject() up until they messed our Outlooks on network with SMART system (for creating and sending cables). Long story... Whenever I click on SEND button to send email to anyone it opens another window (from SMART system) asking to...

Copying all listbox values (multiple records) to clipboard - RESOLVED - Can you actually copy all of listbox values of one column in to clipboard so they can be pasted in to other program (Outlook to be exact)? I have some emails that need to be passed to Outlook daily from listbox of access...

I just think it is nice feature, that, instead clicking in listbox(which select immediately) when you have to go to next/previous record with buttons it select same one in listbox...

How can you have items (records) in listbox select with next - previous buttons? I have form with fields and all of them in listbox, so I'd like to have user click on next/previous button to select record and at the same time to have corresponding record be selected in listbox. Possible...

Can you actually cycle through records in a form with 1 sec. delay? I would have text box showing each record for 1 sec. then move to another until the end... Don't know if it's possible at all and how?

I need to send emails to number of contacts based on query (it collects emails from all contacts) with same subject, message and same attachment daily. Also I wonder is it possible to collect more records and have them placed in one row devided with ";"?

I've seen some examples but never tried it myself. Some help would be appreciated...

I'd like to send emails from query's field "email" with attachment. I have this code, but it only sends the first record... Private Sub Command20_Click() Dim mess_body As String Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Set appOutLook =...

I got it! This refers to Access 2007. I've made a form with warnings that macros are disabled and that they need to be enabled in order to continue forward. I've also made macro with autoexec name. In it I have put: condition [CurrentProject].[IsTrusted]=False --> action OpenForm -->...