Search results

Hello, I haven't designed a database in many years and struggling with different scenarios for days with what seems should be easy to see, but not sure if I am able to. I now feel that I know enough to be dangerous. The database is for a home exterior cladding subcontractor that performs work...

I am need of tracking previously drawn lottery numbers. Would it be best to have the drawn numbers be entered as separate fields in a given record (i.e., Ball1, Ball2...Ball5), or to create a one-to-many join table between a tblBall.BallID and a tblDrawings.DrawID? I am vacillating back and...

I have a subform (Datasheet mode) on a main form (Single form mode). I normally just use the wizard to create a combo box to find a record on a form. However, I cant put this type of combo box on a datasheet subform, so I need to place it on my main form. Question: How do I find a record on...

I am wanting to store an expression as a string value in a bound textbox (example: "=1/(4*8)"), and then use it as a control source in another textbox. Would this have to be done as a VBA function?

I am trying to create a form/subform structure similar to the "Customer/Orders/Order Details" scenario, and I cannot find the exact format I am wanting to create. Specifically, I would like: 1. The main form to list the Customer name; 2. The Customer Orders to be listed in a subform on the...

Is there any way to turn off the currency symbol and keep the parenthesis? I cannot find any info on creating parenthesis for negative values. The currency format seems to be the only format that provides this feature.

I am developing an app for a small medical office that requires a way of tracking periodic health testing for their patients. They are ultimately requesting a report that informs them of upcoming required tests for their patients. Most periodic tests for a given patient will be manually...

Could someone point me in the right direction on how to statically store current pricing for a product in an invoice database, whereby future price changes would not change pricing on past/previously created invoices...?

Shortcut menus on a report are not available in runtime mode... I want the user to have ability to email a report... Ive created a new "reports" toolbar with a "Send To: Mail recipient" command on it and inserted this code into the Open Event of the main switchboard...

:confused: I have a frmServiceOrder form that has a "datasheet type" sfrmSOItem subform with a combo box that allows a user to select service order items... Problem: When I select a service order item in the dropdown, it doesnt place the item in the record...I have to select it a 2nd time...

I've read several previous threads regarding this...but could not find an answer: Is it possible to store a PDF file in a table? I know that I can store a hyperlink with the path to a PDF file located elsewhere, but I would rather store the file in the database itself. If it can be done, how...

Does Access2002 limit the number of fields you can insert into a table?

I am trying to reference a database filename so it will show in a textbox on a form within the same database...I can find no previous threads on this... Thanks for any help.

Is there any harm in using this command on a database that is in a shared environment, AND NOT opened exclusively? Thanks for any factual info.

I have an OrderDetails table that has many records (OrderDetailID's) with like OrderID's (I use autonumbers for all primary keys)... I have a query that has a calculated field to return material cost extensions (Quantity*Cost*TaxRate) for each OrderDetailID record... How to sum OrderDetailID...

I have searched the threads but can't find what I'm looking for... I have a form to enter records...I would like the form to open in Add mode, but also allow record editing capability at the same time...Is this possible? Thanks

I have a calculated expression performed in a text box on a form... How to retrieve/reference that text box value from a text box on a report? I have found similar threads on related questions...but I am very confused... Thanks for any help!

I am trying to import an updated form from a VB protected db... the File>Get External Data menu gives me a dialog box that says I need a password...there is no input box/prompt for me to enter the password...How to do?...Can you open two (2) db's at same time?? Thanks in advance!

I am developing a lead/appointment/sales tracking app for a home improvement company... I have seen in other types of scheduling software a means of entering appointments via a pop-up type calendar feature where a time and date can be selected and entered into a form... Is there some type of...

I have a query that is the record source for a report... Is it possible for a textbox on the report to reference a field that is not part of the record source? If so, how exactly do I create the reference? Thanks for any help!