Search results for query: *

There are actually 2 PCs in question. The first is fairly new but started with Vista and then was upgraded to Win 7. The other machine is brand new and came with Win 7. I am not sure on the 32 bit vs. 64 bit but I can check that out. I was wondering if maybe it is a conflict of some sort...

Access 2003 Hope this helps. OnTheFly

I have a working application written in Access 2000 that has a SQL database back end. The tables are linked SQL tables. It works fine in Access 2000-2003 when on a WindowsXP OS. However, when a computer is updated to Windows 7 OS the response time to do filters and queries on the forms is dirt...

If you are using the query designer in Access, simply add this to a blank column: FieldTitle: 1 If you are using SQL then add to the select part of the SQL statement: 1 AS FieldTitle Where FieldTitle can be any string describing the value and not duplicating any of the field names in the...

I don't work a lot with Macros but from looking at it I have these questions... What are the parameters for Object Type and Object Format? If you are outputing based on a report you can make the data source of the report filter by the ID for the record displayed in the form by adding something...

Powerhouse, If your second form is set so that you can not add records the easiest way to accomplish this is to put this in the Form Load of your second form "Central Sources Journal Entry Form 2004 2": If Me.CurrentRecord=0 Then MsgBox "There are no details for this item at this...

I am unclear how you are getting the data to the Word document. You reference a db report. Are you creating a report in Access and then exporting it to word. Do you have a word document tha is a merge document connected to the Access Table or the SQL? In regard to the criteria for the SQL...

Or Move the where to the qryCountAbsJoin query instead on the final query. Hope this helps. OnTheFly

Hmmm It sounds like it could be a record locking issue where the new record is not being immediately released. I have not had this problem myself but the only suggestion I would venture would be to try one of the other Lock Types on the ADO recordset used to add the record. I Generally us the...

How are you adding the record to the Link Table? Hope this helps. OnTheFly

I don't think we have enough information. The code you are displaying should be fine. What is the code relavent to this before it?

There are two things you can do. To avoid the write conflict you would have to commit the record to memory before they can access form 2. Or you can make both forms unbound, let them enter the data and then they click a save button and you enter the data into a table at that time. Hope this...

At the time the record is saved you would have to query the table with the invoices for the Max value and then increment it 1 and use that as the invoice number. If you have more than one person working in the database at once you definately have to do this at the last minute or you could end...

You can build the report in the body of the email but this is just plain text type stuff (no column headings, no formating, etc). There is no way I know of to actual past a picture of a report into an email. Hope this helps. OnTheFly

If you use a combo box control for them to select the Material-ID you can also pull the approriate information into the record from this combo box by including the fields in the sql of the combo box row source property. These items can be hidden by making their width 0". Then, for example, on...

I think that the easiest would be to use one form and a tab control to split the data. That way when you leave the last field on tab page 1 you can switch over to tab page 2 and they can continue the data entry. I believe the problem you are having with the two forms is that you would have to...

I have run into this with ADO so I guess this is worth a try... Try changing the * to %. Don't know if that will work or not but give it a try. Hope this helps. OnTheFly

Is this on new records or existing records? Is the control bound to a field that you are populating? Where are you putting the Format(Date, "yymmdd")? Sorry for all the questions but it is hard to give you options when it is not clear exactly what is being done. Hope this helps. OnTheFly

In what context are you refering? Is this in a text box on a form, as a default value? In a query? In a report? Hope this helps. OnTheFly

The permissions are set on the SQL server based on your user and the role it is assigned to. Each table is given permissions individually through SQL within the database. If you have set the permissions then I am not sure where to suggest looking but it is worth checking them again. Hope this...