Search results for query: *

I did try this thought process in the vb forum, but I now feel it is more Access specific than vb specific. I'm using Acc XP with a need to later convert 'down' to A97 as well. My form is based on a table with three fields... Task - a text field, Complete - a yes/no and Score - an option...

I've been going round in circles until I'm not sure what I've done and tried. My brain cell has just imploded. And I know the answer must be simple!!! That just makes it worse. Somehow I can't seem to find a similar problem in the FAQ's or search. Anyway, the problem... I'm making a...

Working on my nice little database in Access XP. I have a well-working Query by Form facility that (seemingly) does all I want it to do. Except... When a new QBF starts, the form seems to remember the last query. Is there a way of opening a new QBF which (programmatically) clears the last...

I call up a new form - from an existing form - with a button click... DoCmd.Close 'close the existing "CustomerDatabase" form stDocName = "ActiveCustomers" DoCmd.OpenForm stDocName, , , stLinkCriteria However, using this method, there is a distinct 'flash' between...

Goodness knows why... Or perhaps you do! I created a table for Title to give the Mr, Mrs, Miss etc salutation for people. The Salutation has been made Text and 15 characters long. Data can be successfully entered into the table. There is no associated form for the table. In the Customer...

I'm working on a derivative on NWinds using Access XP. There is a utilities module to detect if a form is open (or not!) prior to opening that form... Function IsLoaded(ByVal strFormName As String) As Boolean ' Returns True if the specified form is open in Form view or Datasheet view...

I am developing a database in Access XP, based on NWinds, to monitor sales for some goodies I want to sell. So far I've got it working fine. In the NWinds example, they used a date picking (form) system for a report that works well - for me. The report sets a public boolean variable to state...

Progressing along quite nicely with a little database for things I'm hoping to sell. My database is based on the classic NWinds one from MS. I have a 'main' order Form with an embedded subForm to itemise goodies sold to an individual customer To help me along, I'm trying to embed a sort of...

I'm plodding away making a database (based on NWinds) to make a control system for a few products I want to sell. I use an Order Form, with a subForm of ordered items (just like NWinds) and have coded the subForm so that it will decrement the stock of an item each time one is ordered. So far...

I am having a really stupid couple of hours here! I have an input form for customer details. The form is a cloned recordset. I wish to make it that a field cannot be used, added to or whatever if the previous field has no entry. (So there can be no Address2 entry if there has been no...

I'm not sure if this can be done? I have created a customer database that is in both Access XP and A97 There is the main table - Customer Database. There are data forms based on dynasets of: *CustomerDatabase *ActiveCustomers *InactiveCustomers *FinishedCustomers And they all work the way I...

Please excuse me being in extremely dense mode - it's been a long day! Running Access XP. I've seen all sorts of things about how AllowBypassKeys will prevent a user seeing the database window by holding <shift> as they open the database. I've even read the code and instructions on the help...

I'm using Access XP Pro Developer. I thought I had these customized menus well and truly sorted - until just now! I'm producing a database for distribution - hopefully - and I need to make it fairly idiot proof with extremely limited facilities for the user. So I developed a new custom menu...

I want to export some data from an Access (both 97 and XP) db to an Excel spreadshhet. The routine I've been given is... DoCmd.TransferSpreadshee acExport,acSpreadsheetTypeExcel19, _ &quot;qryWhatever&quot;, &quot;C:\ with a highly detailed full pathname.xls&quot; As the set database and...

Currently I'm developing a Customer Database in Access XP - but with the need to 'save down' in A97 when it's finished. The database will have very little in the way of existing menu and tool bars because I expect the database to be used by people with very little database use experience. The...

Working in Access XP - but will also need to save in A97. In a working form, I successfully call up a print of a report on some sub-data on that form. All works well using the following... Private Sub PrintTestDetails_Click() Me.Refresh Dim stDocName As String stDocName =...

A well-worn topic, I know. But I am now going round in ever decreasing circles - and we all know what happens then! I'm writing a database in AccessXP - which will need a save in A97 as well. I have played quite a bit with various other threads that explain about making 'coloured tabs' etc...

I have found what, to me, is an unusual problem! I can pass public declared boolean flags between procedures with absolutely no hassle. Except... In Excel, the Sub Auto_Close() procedure seems to set any of these flags back to 'False' as the sub proc starts running - no matter what I do...

I did have a thread earlier with calendar problems... thread702-713204 which gave me some food for thought. But I'm not one to let go (too much) sometimes - when I really get stuck into it. Further research in the forum found me... thread702-595839 where there is a nice little calendar...

I have successfully used the calendar system in an Access XP database design and am (so far) pleased with the results. Now my daft question... I used an ActiveX control to call this up - and registered it. If I pass the database that includes this ActiveX calendar to another user - one that...