Search results for query: *

Hi, I have two fields: Division and Project no. Division belongs to Division A, Division B, or Division C When a project is created it is first assigned to a Division and then given a autonumbered Project no (Autonumbers are consecutive- they are not unique to each division. So Division A can...

I have a database which runs perfectly on all users computers w/the exception of one person. One individual can open the database, however when trying to access forms the message "Unexpected error from external database driver (12294) <error 3275> pops up. Since this dbase works fine on...

QryFieldTotals below gives all records that have [SOType]=kdb and [Status]=Is Null. QryOrderForecasts below gives all records with [OrderComplete]=0 and includes the [SchedShipDate] and [SchedShipQty] The problem is that a record, which is an order, consist of [FSONO] and [SeqNo]. It can have...

Paul, There are no subforms, just controls. Any suggestions? Also, what code would I use to keep it on that record when the <Enter> key is used?

PHV, Could you elaborate more specifically on what I should do. PaulF. I tried your suggestions, but it did not work. Any more suggestions? Strangely, I thought current record worked in a past database I did. Not sure why it is not working now.

I have frmDCNumbers. When users hit the enter or tab key from the last field ([notes]) I would like the cursor to go to the first field [Qty1_Cost]) on the form. I tried to set the Cycle property, but it does not appear to be working. Suggestions?

Problem fixed. I did not release my open macro had the form set to read only. FrmOrderDetails in based on linked table which I did not wanted edited, however the recordsets are not updateable.

I have frmOrderDetails which has a subform frmOrderForecasts. The are linked by field FSONO. Problem is that I can only edit, add to or delete records in frmOrderForecasts (subform)if I go to design view then preview view. I'm stumped. Even the "Return to Main Menu" control button which has a a...

Leslie, You were such a big help. How are you with forms and subforms?

Thanks! All I had to do was remove the second criteria and not edit the inner join. Kim

Leslie, Unfortunately this only gave the row totals. I had an idea. I created another query (with same critera) that included FSONO, FOrdQty and FAmount. I grouped by FSONO and did the sum for each field. That gave me the total for FOrdQty and FAmount when the sales order# (FSONO) is typed in...

Here's the SQL: User's will answer one criteria: Enter Sales Order no. This can yield one or more records. Right now, I just have calculated fields on the forms, however it would be easier to have everything in the query to simplify reporting. I appreciate any help...

I have qryOrderDetails with 9 fields. I would like to total the columns for two fields: Price and Amount. How can I add the calculated field into my query? Do I need to create a separate query to do this?

SendObject command was the fix. Thanks! Storing the link online would too much work since this is a confirmation report for items being returned.

Hi, I have an access report which we would like to email customers at random. Is there a way to run the report and have it automatically inserted into an email message. We are using Microsoft Outlook for email. FYI: I created a marco to open the report and output it to html format, however...

Correction: Last sentence should read....... The only time it perfectly positions.......Sorry

I have a form with three pages. Page two and three have subforms that are linked to page one fields. I created two command buttons w/macros: one to advance to page 2. This works perfectly and positions page 2 in the upper left corner of the screen, most likely since it sits directly under page...

Just installed Canon Camera Window on my Computer w/ Windows 98. Now, when I go into the program, my computer locks up. When I look to see what programs are running, I see. msqsrv32 Not responding. Any idea what's causing this and how to fix? I have Gateway go Back, but there is no event...

Roy, I set data entry to "Yes" and it worked like a charm. Thanks so much. Wish I spent less time on this and posted sooner. -Kim

How would we go about doing this. Someone once posted to enter the following: C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /runtime "drive:\path\file_name" but it did not work. Is the Packaging and Deployment a special feature to Access?