Search results for query: *

I am very much a novice with Visual Basic - in fact I know next to nothing about it. Here's what I want to do. I have a form to which I want the user to be able to click a button and have a file dialog box open up. I'd like the user to select one or more photos to put on the form. I want the...

I want to be able to have some sort of database for writing letters. When I write a letter, I want to be able to select off who it is to, and then simply type in the text of the letter. Also, I want the database to automatically number the letters sequentially. Is there a pre-made access...

I am a project engineer in the construction industry. Our company is very cheap when it comes to buying software. When we need to track submittals on a project, we usually track them in a GIANT excel spreadsheet. And though I am very much an Access beginner, even I can see the huge benefits...

I'm having a problem with my form subform. My form is for employees, and the subform is for their wages as well as the dates those wages are valid. For example, Employee Joe Smith might have 2 entries in his subform: The first entry says he earns $25/hour between 6/1/02 and 5/31/03. The next...

I have a form for entering daily costs on a construction site. The user enters the date that work was performed, the quantity of work performed, the applicable cost code for which wwork was performed, and finally the cost incurred on that date to get that amount of work done. Each type of work...

Say I have a form that contains a look-up field. That look-up field contains whatever.....say names of people. When I go into that look-up field, how do I add a new name directly to the look-up field (and have it populated to the source table of the look-up field), without having to exit that...

I have a field whose value gets calculated on a report. The control source of the field is "[DailyBudget]-[DailyCost]. This is a field that I created on the report itself - it doesn't show up in the query on which the report is based. How do I get access to store this calculated value...

In a query, I have an expression that calculates a percent over budget as follows: % Over: Abs([Gain/Loss]/[ToDateBudget]) Compounding the matter is the fact that sometimes the loss is greater than zero, but the budget is zero. Since I can't divide a number by zero, PaulBricker helped me...

I have a query that I am using to select all cost codes that have gone over budget. The qry has the following fields: CostCodeNumber CostCodeDescription ToDateBudget ToDateCost In addition, I have added the following expr. to the query: Gain/Loss:[ToDateBudget]-[ToDateCost] The next...

I have created a report with an embedded chart. The report prints out the following info: WorkDate: The date that work was done on a construction site for a particular cost code DailyHours: The number of hours spent on that cost code on that day DailyQty: The quantity of work that got done...

I would like to export and email a form to single person all with the push of a single button. It's probably not that important for you to understand the contents of the report - except for the fact that each report has a unique date. To make a long story short, the report is a "daily...

Ok here's the deal- I have a form in which the user enters a start date, an end date, and a 6-digit cost code. From this data, the user hits a button that generates a report. The dates the user enters correlate to a construction phase for a jobsite. For example, Phase 17B occurred between...

I have a switchboard that I created from Switchboard Manager - so it already has an [Event Procedure] in its OnOpen property. I'm a novice user and I would like to know how to have the switchboard maximize automatically whenever the user opens the Database. I'm guessing I need to add...

Novice user here. Having trouble getting DSUM to work in a query. My expression is: DSum(&quot;[CostCodeQuantity]&quot;,&quot;tblDailyBudgetIntermediateTable&quot;,&quot;[Date]<=&quot; & [Date]) The problem is that when I run the query, nothing shows up in this new field. What did I do...

Here's what I am trying to do: On my report I want Access to calculate a cumulative amount- I want a report like this (sample data) DATE QTY HOURS CUMULATIVE_QTY CUMULATIVE_HOURS Nov1 50 8 50 8 Nov2 70 10 120 18...

Is it possible to export a report to a .pdf file? I have a report that has some color in it. These color features do not show up when I export them using anyone of the file formats that Microsoft makes available. So I thought they'd probably show up if I can get them in a .pdf file. Plus...

I'm a beginner Access user who is having some troubles with using a combo box. Here's the deal: I have a table of cost codes. Each cost code has a series of attributes. I have created a form with a field for cost code. I want this field to be a combo box so that I can simply select the cost...

I am a beginner user and am having trouble with a simple DB I'm trying to create. I want to track delivery of stone to a jobsite. A separate supplier (Vulcan Materials) supplies three different types of stone. The stone gets delivered to the jobsite by a separate trucking company (CTI). Both...

I have created a form based on 2 tables. The form contains 5 fields: StoneType CostCode DeliveryDate TicketNumber Weight The first 2 fields (StoneType and CostCode) come from 1 table. The other 3 come from the second table. I am having a problem only with the 3 fields from the second table...

I am setting up a databse to track RFIs (Requests For Information). The first RFI I will type in shall be given the number 0001. Subsequent RFIs will be 0002, 0003, 0004, etc. I know that Autonum will do this, but here's my issue: (Keep in mind I'm a beginner Access user). During the...