Search results

Thumbs up on the new swtichboard look. Nice logo too. In your tables I see 'computanet' entered many times. Consider making another table to hold PC brands, Monitor brands etc. Then relate the brand to your first table. Good Luck Tom

Acidburn Make sure you drop the complete baswipe module into your modules section. Then this is what I use in my forms close event... Dim lngIncrement As Long Dim lngOpt As Long lngOpt = 5 If lngOpt >= 0 Then lngIncrement = 100 Call WipeEffect(Me, lngOpt...

Here is a link that might be what you want. download wipe/move/resize http://www.candace-tripp.com/_pages/access_downloads.asp Tom

Pat Did you already have a look above? At the second post called Recomended Reading List. Tom

Rich Thank you for the reply. I implemented the wizard and then tried to chang the query to an update query, but I received an error saying it could not update the CustomerID field. Any ideas? Tom

I am trying to repair a db. The Invoice table has the Customer's name stored, but not the CustomerID. I would like to repair the tblInvoice table data. I'd like to have a query that looks up the customer name, then enters the proper customerID in the customerID field. The customerID will have...

Perfect! Thanks once again Wayne. Tom

Hi I have a field in a table called 'Location' The problem I have is the user has typed in data for "Location" and 'Area" I would like to split the data. I think I should use an Update query. Now I need help with the criteria. Here is a sample of the data; The first part 'PEEJAY' and...

I am trying to use a query as the record source for my InvoiceSub form. I have enclosed a gif of my QBE. If I erase the 'sum' part of the calculation, the query opens. Anyone know what I'm doing wrong here? Tom ps: I enlarged the pic.

Dan This is a guess. If any of your dates are formated like this Now() or Date() ... They have to all be one or the other. Mixing the formats can cause errors. HTH Tom

Hello I have a Subform (on an Invoice form) that I have been using a table as the record source. The sub form is set to datasheet. I have been also using a bunch of dlookups on the subform. I want to get rid of the dlookups, so I made a query that does the job. My problem is... now that the...

Steve Sorry. That isn't the problem. The only thing I can think of is to check the forms where the toolbar is supposed to be present and make sure it is listed corectly in the forms properties. Tom

Jon There are a few really good tutorials on querys here... SQL There is a tutorial specificly for perameter querys here.. Perameter querys Good Luck Tom

Steve You might check your new db menu Tools>>StartUp to see if the Allow Biult In Toolbars is unchecked. HTH Tom

Pat Right you are. I was confused as to how the 'Packager' worked, or even what it was called. After reading the articles that WindSailer has posted, I see that the packager just installs Access with your application. spacepro I am trying to use VB6 as a front end on a project right now, but...

mmccl There is a sample here Compact BE HTH Tom

Hootie You need the "Developer" edition (I think its called) of access to produce stand-alone programs. And its pretty expensive. But... it can be done. Tom

Smith What do you mean, "demonstrate the count" ? Tom

Pat There is a tutorial here that might help. Querys On The Fly Good Luck Tom

There is a good tutorial here... SQL Make Table HTH Tom