Search results

DoCmd.SetWarnings False

Hi Forum, I'm building a db to track computer and user problems for work, where I double as a Client Support Administrator (IT Guy). I have these tables: (simplified list) tblComputers tblPeople tblCompAssignment tblProblems I'm at a loss as to how to link the 'Problems' table. This is...

It's not for me, unless I use the wizard to create the listbox. Did you check the column count?

Look at the format tab for your listbox and see what your column count is...change accordingly.

In the front end, try turning OFF 'name auto correct'. Go to Tools/Options and on the General tab, on the right-middle, de-select 'Track Name auto correct' and 'Perform Name auto correct'. That should help quite a bit.

What are the data types for these things? ... Me.HistAutoNo & ", " & Me.Text58 & ", " & Me.HistEntBy

Are you using the domain username to automatically log their name for the trouble ticket?

Why do you need an image path loaded in the image control? For dynamic images, I add an image control, select a picture, and then remove the picture...leaving an empty image control.

Excellent, glad to help.

You probably want to use WrdApp.Documents.Add() From the Word Help files: Add method as it applies to the Documents object. Returns a Document object that represents a new, empty document added to the collection of open documents. expression.Add(Template, NewTemplate, DocumentType, Visible)...

For starters, you've declared two destination fields (candid,skillid)...but you're only trying to put a value into 'candid'. It is looking to fill every declared destination field.

I finally found a copy of the app I described. I laughed when I finally realized how I went about this task 2 yrs ago...it is so juvenile! It uses a 'tables' table and a 'LinkPath' table. Basically, the startup form has OnLoad code that checks to see if all the linked tables are OK (using a...

I have handled a case just like yours. Here's what I did: I made a 'tables' table...with fields that would identify what site each entry was for, the table name, and the table path. I shipped the front end with no linked tables, and using some logic at startup, the "Where are you" form would...

You can export a query as well. Make a query that will filter the record you need.

Get *real* creative and put it all in one query... or use subreports. If you elaborate a bit further, someone here may be able to point out a better way.

Just to add to that... It is better practice to resize your picture using a graphics program. Smaller file size=faster loading. Every Kb counts.

Is the webpage stored locally on a *web server*? I don't know of a way to have a data-enabled web page without a web server. If you do have access to a local web server, it's not rocket science to display and update records in the database.

Cool. Yes, True = -1 in Access. You did marvelously...don't tell anyone that you 'know' Access...it will never end!

What I would do with the tax is this: -Forget about the 'Taxable' yes/no field. -Store the TaxRate in the transaction table (wherever the ItemCost lives). -You can enter 0 or whatever the tax rate is in the TaxRate field. -Wherever you are pulling the sale data, just use ItemCost * TaxRate...

1. Make a query for your report. 2. Under the 'AuctionID' field in the query, in the criteria block...right click and select 'build'...in the list on the left side of the dialog, navigate to your form and select the AuctionID field from the middle. 3. In your report, select the query as your...