Recent content by NickH1

Unfortunately, in this case, I am not talking about code I am talking about plain manual exporting. I may yet have to resort to writing a macro which calls a bit of code. And I thought Access 2007 was all about making the user interface easier for none-code-writing users. Please excuse me...

I see the Husky is on my trail! I know this could develop into a long thread but... whether you have a single file for stock movements or separate files depends on the level of detail you want. E.g. a Sales movement relates to a customer, a Receipt movement relates to a supplier and a stock...

You should keep each bit of data in a separate table. In this way you retain a complete picture of what has happened. So you might have:- 1. Customers table (Customer ID, Name, address etc) 2. Product table (Product code, description, price etc) 3. Sales table (Date, Customer ID, Product, qty...

In earlier versions the default path for exporting to Excel was the database path. This is not the case now and Access defaults to the users Documents folder. Of course in the world of business this is never where you want to export to. Is it possible to set the default export path. I see...

Re: Access 2007 Excel exports You CAN export a query to Excel 2007 in Access 2007 DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "MyQueryName", "C:\MYxlsxFileName", True

I would do this by making the combo-box where the Student-id was selected 'unbound', but make its source the same list of students. In the AfterUpdate of the combo Find the matching record using a recordsetclone and then set the form bookmark to the clone bookmark, then display the fields. Use...

The point of this discussion is trying to emulate a 'right-click' menu. Those menus have no buttons and when you click on something else they automatically close.

Not sure what you are trying to achieve, I'm afraid. Anything can be shown in a msgbox as long as you convert it to a string (up to a character limit of 255 though!) You can pull lines out of a listbox easily but separating lines from a multi-line textbox is harder. It still sounds like using...

What are you trying to do here? It looks like you are trying to display a record after selecting from a combo but also trying to add a new record if the entry you are looking fro does not exist? Is that right?

In msgbox do Msgbox "My first line of text" & vbcrlf & "My second line of text" vbCrLf puts in a line break. APIs are Windows low level functions. To write on a MsgBox you would have get directly to the window 'handle' and then use draw routines - basically to do it the way Access does it. I...

I like your idea! If you use the pop-ups on more than one form you do have to add code to each form. In my case the object underneath the popup is a grid where I am implementing click and drag operations so it is a bit more complicated. Might still try it some time though. IsLoaded was...

You can do most things with queries so it is worth investigating what they do. SET UP YOUR MEMBERS TABLE - Make sure your table has a unique key for each member (Primary Key). Ideally an ID but if not you may have to use a combination of fields ( e.g. Full Name + zip code) That way it won't...

Using LostFocus to do the update makes the flow of code here difficult to work out. Are you sure it will lose focus? Why not use AfterUpdate and then debug your code looking at the bookmark value. Showallrecords will update the recordset and invalidate bookmarks.

Or the 'official' way For Each tdf In CurrentDb.TableDefs If (Left(tdf.Name)="temp") Then ' this is one End If Next

Unless you are doing really intensive stuff you won't see any difference. I guess that public variables would be more efficient than hidden fields as they require more data to be stored (all the properties) and reading and writing to them requires a lot more processing. Public variables can...