Search Result

I have an access database. I am using a send email macro to automatically send an email when a condition exists, but I cannot reference a related field in a related table.
I keep getting a message in the log saying "The identifier '[tbl Job References].[YR Number]' could not be found."

Can this be done?

Hi there,

I need help with a report I am trying to build for work. I have a simple for called "AuditTotal " with two Date/Time fields "start_Date " and "end_Date" and an open report button. My report has a query called "AuditPTETo tal" as it's record source.

Once I fill out the dates and press the open report button, I would like the report to show up and display the data retrieved...

Hi everyone,

In our desktop application projects we use setting variables to store user setting for the applications. Moreover, with every latest version of the applications, we upgrade these variables to retain user settings.

Normally, this works fine, but recently one of my end user reported an error i.e. “Configuration System failed to initialize”. The error is related to “user.config” file. Therefore we...

Hello all.

I am trying to use DLookup to auto-populate fields in an otherwise simple database. I am using Access 2010. I have created three different databases and the code still does not work. I think there may be glitches in this particular copy of the program. Please evaluate the details below and tell me what you think.

Table 1 has fields: Product ID, CustomerName, CustomerAddr, and ComplaintLevel.

Table...

I migrated a database from Microsoft Sql server 2005 to a MS Sql server 2008 box. On the old server the under security/users the information_sch ema and sys accounts were active. When I try to enable them using:

Grant Connect To Information_Sch ema the command completes but I get a message stating I cnanot enable this account.

What do I need to do grant these accounts Connect?

this is causing some software...

I am creating a form in Access 2003. It has 3 subforms in it. Because of all the data in the form i need to be able to scroll since not all the information will fit on a single page.

I have gone to the scrollbar property box and set it to have a scroll bar both horizontally and vertically. The problem is, even after doing this there is no scroll bar going vertically. There is a space where the scroll bar should be, but there is no...

I have one table with the majority of the information. This table holds the following:
SalesRep (lookup from another table)
Invoice Date
Date Paid
OE
Customer
NetSale
GP
Adj GP
Rate
Paid Amount
Paid in full?
Additional Notes
Commission Payout Date
Bonus Amount

I have a query that calculates the commission by multiplying the rate times...

My question is... Is there a way to place a link to a .pdf file into Access where if you click it from a database it will pull up the file? I don't think there is but it's worth the time to ask. Thanks.

I know it is possible to have multi-user Access database on a local server but I do not have a server. What is the best way to create a multi-user Access database that can be accessed by any computer with internet connection and doesn't require a server (free options are always preferred but I could spend some money).

Thanks

Hello,
Access version 2002, SP3
This is my first post ever, so please be kind. Problem: I have a command button that "selects all" check boxes in a subform which is based on a table(datasheet view). I have another button that deselects all check boxes. I can do one or the other, but only once without exiting the form and restarting it. In other words, I can select all, but i want the end user to be able to deselect in case...

Ok say i have a form pulling from a table(call is table A)
and the first combo box hold an integer that is a auto number starting at 1 (which in this case is the same number as the current record I'm in)
what i would like to do is run a query in another combo box on the same form which would look something like

Select ID
From Table1, table 2
Where Table1.ID = Table2.id

My problem with this...

Can anybody tell me, how I can get a breaks-collection for a word document?

Hello all!

I'm having a strange issue happen from a recent upgrade from Outlook 2002 to 2003. Here is a dumbed down version of the main loop I'm using to debug the problem:

...

Hi all i was wondering if any one could help me i'm tring to build a view by month calander to show client appointments i have a text box which starts with the current year which i'm planning to be able to change up and down at a later date using buttons but what i'm stuck on is selecting the current month in such away to link in with a table with the months inside and the number of days in each one partly so i can adjust the number of days for leap...

Hi, im doing a college project, which is a banking app, it is more or less fully functioning, the user can log in and check their balance, but i have trouble setting up a transfer function, so the user can transfer money from their account to the chosen account. I am using access though JET for it. My efforts thus far have only got it to change the balance on the primary account. This is my open connection code which is activated when the user clicks...