Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 408
Search took 0.03 seconds.
Search: Posts Made By: mike60smart
Forum: General Today, 12:42 PM
Replies: 10
Views: 104
Posted By mike60smart
Re: Table Design Multiple same name cities in state

Hi Tim

I believe your process would be:-

1. Select a Job
2. Record Date of Inspection
3. Select Type of Inspection
4. Select SubInspection Value
5. Enter Inspected Value
Forum: General Today, 12:40 PM
Replies: 10
Views: 104
Posted By mike60smart
Re: Table Design Multiple same name cities in state

Hi Tim

I also don't think you need tblInspectionEventRecordedValues
Forum: General Today, 12:35 PM
Replies: 10
Views: 104
Posted By mike60smart
Re: Table Design Multiple same name cities in state

Hi Tim

I think you need Cascading Combobox's for Inspection Types and SubInspectionTypes.

Would you want to be able to select an Inspection Type and then only see those Sub Inspection Types...
Forum: Forms 08-18-2019, 06:29 AM
Replies: 4
Views: 142
Posted By mike60smart
Re: validation in access for fields

Hi

You need to use Cascading Combobox's
Forum: Forms 08-17-2019, 12:52 PM
Replies: 26
Views: 302
Posted By mike60smart
Re: sub form as form view not datasheet

Hi Liz

If you do a Compact and Repair you will reduce your db from 286 Mb to 1 Mb.

Try that and also see if you can go into the VB Editor and Compile the Database.
Forum: Forms 07-28-2019, 07:30 AM
Replies: 8
Views: 165
Posted By mike60smart
Re: Access Continues Form With Form.open Event

Hi

Your table DDL Master looks like a typical Spreadsheet.

Can you explain what each of the field names represent?

75713
Forum: Tables 07-28-2019, 06:55 AM
Replies: 6
Views: 169
Posted By mike60smart
Re: Access Table Structure

Hi

Can you upload a screenshot of how you currently record this information?
Forum: Queries 07-26-2019, 05:28 AM
Replies: 9
Views: 167
Posted By mike60smart
Re: Weekly monitor based on query result

Hi

Are the notifications reminders of some sort?
Forum: Queries 07-26-2019, 05:25 AM
Replies: 8
Views: 175
Posted By mike60smart
Re: i keep getting aa prompt box asking me to enter a parameter value

Hi Mike

You would not use the query as the Record Source for your Form

You should create a Form based on tblStock
Forum: Tables 07-23-2019, 12:25 AM
Replies: 12
Views: 263
Posted By mike60smart
Re: Plus symbol on table

Hi

Yes if you make a zopy and remove all data we can take a look for you.
Forum: Tables 07-22-2019, 12:33 PM
Replies: 12
Views: 263
Posted By mike60smart
Re: Plus symbol on table

Hi

Can you upload a zipped copy of the Db?
Forum: Tables 07-22-2019, 12:19 PM
Replies: 12
Views: 263
Posted By mike60smart
Re: Plus symbol on table

Hi

Your tblNoticeInfo has the following field set as a Primary Key - EntryID_Info

Is this field set as an Autonumber ?

Your other 2 tables do NOT have any Primary Keys ?

What Data Types...
Forum: General 07-12-2019, 07:22 AM
Replies: 29
Views: 411
Posted By mike60smart
Re: Volume tracker in access

Hi

So how is the actual data received by the Users? Is it by Telephone?

How many users would be using the database at any one time?
Forum: General 07-11-2019, 07:45 AM
Replies: 20
Views: 268
Posted By mike60smart
Re: Fill Fields Before Reports

Hi Billy

Ok you go with whichever option suits
Forum: General 07-11-2019, 07:31 AM
Replies: 20
Views: 268
Posted By mike60smart
Re: Fill Fields Before Reports

Hi Billy

OK I have added a message to the Clerk form On Open Event

See if this suits

75481
Forum: General 07-11-2019, 07:25 AM
Replies: 29
Views: 411
Posted By mike60smart
Re: Volume tracker in access

Hi

The problem is that we do not as yet understand what it is you need.

Can you explain Step by Step what it is you need to do.

If you can use a pen and pencil to create the various tables...
Forum: General 07-11-2019, 07:20 AM
Replies: 20
Views: 268
Posted By mike60smart
Re: Fill Fields Before Reports

Hi

Yes you will get this error because there is no data for your Preview of the Tear Down.

Normal Process is fill in all fields and Save the Record.

Then Preview the Report.

If you miss...
Forum: General 07-11-2019, 06:52 AM
Replies: 20
Views: 268
Posted By mike60smart
Re: Fill Fields Before Reports

Hi Billy

I added the following to your On Click Event "Print Tear Down"


Private Sub PreviewTearDown_Click()
If Me.Dirty Then Me.Dirty = False
If IsNull(Me![AFRNumber]) Then

...
Forum: Queries 07-11-2019, 06:08 AM
Replies: 4
Views: 128
Posted By mike60smart
Re: Query not working when one field is not filled

Hi

That is the SQL View of the query can you switch to Design View and then post the relationships
Forum: Queries 07-11-2019, 05:26 AM
Replies: 4
Views: 128
Posted By mike60smart
Re: Query not working when one field is not filled

Hi Can you Post a screenshot of your Relationships in your Query?
Forum: General 07-11-2019, 05:15 AM
Replies: 20
Views: 268
Posted By mike60smart
Re: Fill Fields Before Reports

Hi

In the Before Update of the Clerk Form I placed the following Code:-


Private Sub Form_BeforeUpdate(Cancel As Integer)

On Error GoTo Form_BeforeUpdate_Error
Dim ctl As Control
Dim...
Forum: General 07-09-2019, 12:38 PM
Replies: 29
Views: 411
Posted By mike60smart
Re: Volume tracker in access

Hi

Why put exactly the same data into a table multiple times??
Forum: General 07-09-2019, 12:27 PM
Replies: 29
Views: 411
Posted By mike60smart
Re: Volume tracker in access

Hi

Your tbl_Bala has lots of repeated data as shown in the attached.

What data is in Sheet1???

75467
Forum: General 07-09-2019, 10:37 AM
Replies: 29
Views: 411
Posted By mike60smart
Re: Volume tracker in access

Hi

Not following your process.

You say "Data which i am entering in ONFS_Vault should save in tbl_Bala"

What is ONFS_Vault ??

If you want to store data in tbl_Bala then you would create a...
Forum: General 07-09-2019, 10:30 AM
Replies: 29
Views: 411
Posted By mike60smart
Re: Volume tracker in access

Hi

You have data in 2 tables - tbl_Bala and Sheet1

How are these 2 tables related?
Showing results 1 to 25 of 408

 
Forum Jump



All times are GMT -8. The time now is 01:57 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World