Search results

Please can anyone help... I want to have line item numbers on report look like this: Number....Order Number 1............9533-1425-20 2............5866-3411-14 3............2332-2355-14 3............2332-2355-14 ->repeating item 4............4399-5208-12 5............7392-2305-62...

I have this problem: I want to import customers’ names, emails and their office code into my customers table. Names & emails are fine (text), but in my database office field is number as lookup to OfficeID in office table. So now I’d like to have formula or VBA code to check text filed of...

I'm trying to export module directly from one database in to another, but I'm getting error #29068 when using DoCmd.TransferDatabase I was able to export macro (which I need also)... DoCmd.TransferDatabase acExport, "Microsoft Access", strFile, acModule, "basFEUpdate", "basFEUpdate"

Hi, all I have unbound combo box based on query. I'd like to have another button which select next record in that unbound combo... (similar to next record in bound form). Is this possible? I've tried using code to select ListIndex of that combo box but it gives me error - Invalid use of...

I have SharePoint list inserted as linked table in Access 2007. When I need to refresh list I need to delete all records in that table and append new records (not all of them are new - some are existing). This works fine but it always shows NEW next to all items (I know why - for this list...

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 (,)...

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...

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

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)...

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...

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'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 =...

So, I need to make sure that there is NO SECURITY WARNING message when opening my database in Access 2007, because I have some procedures than will not function otherwise. I googled it but I was only able to find VBA code for Excel 2007. Any clue here?

Is there a way to save temporally value of combobox? I have form set on data entry and combobox with value of another table. Every time I go to next new record combobox value is reset to default one. I'd like it to stay on previous one...

I have one unusual problem to solve… There are a lot of PDF files (over 160) with unique name (Spec_385912347657_200909) that are actually phone bills that need to emailed to a customer in database. I need access to disregard first 5 and last 7 characters, do the check within the database, and...

So, I have form with fields of table for new entry and subform table that is showing all of records (Master - child fields links are empty) and that works fine. Now I'd like to make search button that can search ALL the fields in table and show them in subform table. Any ideas?

Hi all! I have form based on one table with data to be entered and I'd like to include sum of data of a query. It is basically sum of money obligated in a query that I'd like to be shown on a form where you can enter new data. The problem is if I create a query (SELECT type) with all of the...

I have form that is set to DATA ENTRY on (name of a customer) and list box of shelves names based on a table and this is what happens: When a shelf is selected and customer is entered (trough combo box) the value of shelf is set to default (none selected). So I'd like to have shelf name in...

Hi! I get an error when summarize a field in datasheet when no record is showed. Let me clarify: I have main form with datasheet subform in which I have unbound textbox that calls another unbound textbox in subform (this one summarizes how many items one customer has) So you can search...