Search results

This is a tricky one... I'm using the 'cmd' command line option to pass information to my database. The idea being to have the ability to pass an identifier via the command line that could be parsed by the database which would open automatically on the relevant record based upon the command...

Hi, I have a split B/e F/e Database. The B/e resides on a Server & each Client has an MDE file. Also involved is a linked Database which I use as a resource for shared company-wide data. The B/e database has linked tables from this Database. So in the MDE file there are Forms, Queries that use...

Hi all, Anybody got any ideas on how to display an animated GIF on a form? Thanks in advance, Patrick.

Hi, I have a query showing Support response times in days. It returns the amount of days for each record in the database based upon the DateDiff of two dates. I'd like to be able to view this information based upon criteria, I.e. I want to see a count of records between 0 And 50, between 50 And...

Hi, I've replaced a couple of my standard textbox controls with RTB controls to allow formatting of individual lines of text etc. This is all working fine in Forms. Due to the way RTB controls work (they store formatting tags within the text in the database) I also have to replace the Textboxes...

Hi all, In my database I've replaced my usual text boxes with RTB controls so I can apply extra formatting. I'm creating a set of buttons or a menu item to control Bullets, Bold, Italics etc. The problem I'm having is determining which control has focus. Ie. in order for my buttons to work I...

I recently came accross two brilliant freebies at: http://www.pb-sys.com/ Buggit is an Error tracking database & TCM is a Test Case Manager. Both are Open Source Access Dbs & well worth a look. (If you're interested in that kind of thing..) Regards, Patrick

Hi all, I’m looking for some opinions on the following scenario please: Currently my company uses lots of different databases: A Database for tracking support calls A Database for tracking Software Errors A Database for storing Employee TimeSheets (It goes on…) I want to normalise...

Hi all, I have a database which will contain a large number of records. With this in mind I've created an empty copy of the main table. The idea being that when the database gets slow, the Admin will have the option of transferring records which arent current into this table. The problem is...

Hi all, This is the process I'm following: 1. The user selects criteria from list boxes on a form then clicks a button. 2. A paramater query is built on the fly using the criteria selected. 3. A Form is then displayed using the query as it's recordsource. Ok - I've done the above, my problem...

Hi, I have a chart on a Report, the report is based on a select query which gets parameters from controls on a form. The problem is that the chart throws a wobbler & doesnt recognise the parameters - I assume this is because it's rowsource is a subquery of the reports main query. Cutting to...

Hi, I'm trying to open the Access Find function for a subform, I've tried: screen.PreviousControl.SetFocus DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70. I've also tried using SendKeys & RunCommand The problem is that I want to open the Find for the subform by clicking a button on...

Hi all, What I'd like to do is: In the after update event of a certain field on my form, I'd like to validate other fields on the form before allowing the user continue. I don't want to go down the if [field].text = "" etc road as ther are a lot of fields on the form. What I'd like to do is...

Hi, I have an invisible subform on my main form. The form is made visible based upon options selected in a data tree, i.e. if a certain node is clicked then set the recordsource of the subform & make it visible. What I want to do is: When a certain node on the tree is clicked, show the form &...

Hi all, In my database, I have a field called "Comment". I'm displaying Continuous forms so I don't have a lot of space on screen. With this in mind & as the Comments field is optional I decided I would include it as a Popup - Double click a field & the following code runs: 'Build the SQL...

Hi all, I'm currently working on a multi user database which will be used be approx 50 people. This is the second phase & the initial phase is up & running until I replace it with the latest version. The thing is.. At the moment, everybody connects to the database via a shortcut to the opening...

Hi, Currently I have a Db which stores Time sheets. The user fills out their weekly timesheet then submits. (A Filter is applied per-user so that only their own records are visible to them). A query then runs in the background & flags all of the submitted records to "Submitted" & makes them...

Hi all, Just wondering if anybody has any thoughts on the following? At the Autoexec event, an append query runs, gathers the latest data from another database & appends to a table in the local database. What I want to do is: For each item returned from the Append query, prepend "CR". I.e...

Hi, I'm probably doing something stupid but... It is Monday morning & I need help.. I have a Generic form. I want to set the forms RecordSource in code so that I can open it from other Forms using different recordsources. The form has two fields, "Comment" & "Record ID" Currently, in the click...