Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 95
Search took 0.03 seconds.
Search: Posts Made By: Cark
Forum: Forms 07-15-2019, 06:02 AM
Replies: 7
Views: 169
Posted By Cark
Re: How do I tell MS Access to look for a Text Box on a Page?

If the Tab Page Name was something with a space e.g Customer Support would I use Customer_Support or [Customer Support] in the place where Reliability is?
Forum: Forms 07-15-2019, 02:53 AM
Replies: 7
Views: 169
Posted By Cark
Re: How do I tell MS Access to look for a Text Box on a Page?

Hi Arnel,

Can you explain why the Me.FrmSubReliability.Form!PartID part works? Why does it not need to be Me.FrmSubReliabilityProgramme.Form!PartID?

I have another SubForm called...
Forum: Tables 07-12-2019, 04:04 AM
Replies: 11
Views: 296
Posted By Cark
Re: Removing Row Blocks

I have just tried using a Multiple Items continuous form, but have been unable to make it so that I can add entries to it when it is used as a subform in FrmSubGeneralInformation. It says You cannot...
Forum: Forms 07-12-2019, 03:36 AM
Replies: 7
Views: 169
Posted By Cark
Re: How do I tell MS Access to look for a Text Box on a Page?

Hi Arnel,

I tried putting your snippet of code, but it did not seem to work.

Also the Description boxes will have different text for each part number so I don't think the code should involve...
Forum: Tables 07-12-2019, 02:42 AM
Replies: 11
Views: 296
Posted By Cark
Re: Removing Row Blocks

I'm not sure I am understanding this correctly...

I am wanting to see all the Descriptions for that Part Number simultaneously. Can this be done? I don't want to make the user click through the...
Forum: Forms 07-12-2019, 02:39 AM
Replies: 7
Views: 169
Posted By Cark
How do I tell MS Access to look for a Text Box on a Page?

I have a Form which has 2 Tabs which contain separate aspects of information that are related to the same PartID.

What I am trying to do is to come up with a method so that if there is a...
Forum: Tables 07-12-2019, 01:53 AM
Replies: 11
Views: 296
Posted By Cark
Re: Removing Row Blocks

I had already tried Record Selectors set to No and they were still showing.

If I understand it correctly a Continuous Form would require the user to use navigation buttons to switch between the...
Forum: Tables 07-11-2019, 11:24 PM
Replies: 11
Views: 296
Posted By Cark
Removing Row Blocks

NOTE: I am struggling to find exactly what they are called, so I am happy to rename the title of the thread once identified.

I currently have a Table being used as a Subform on a Form so that I...
Forum: Tables 07-11-2019, 11:03 PM
Replies: 9
Views: 243
Posted By Cark
Re: Forcing A Field's Data Type To Be Currency In Dollars ($) Instead Of Regional Set

Just to clarify, all costs will be entered into the database in $, so having data with ús will not be necessary in this particular database.

If I understand the suggestions correctly, I would be...
Forum: Tables 07-11-2019, 04:06 AM
Replies: 9
Views: 243
Posted By Cark
Forcing A Field's Data Type To Be Currency In Dollars ($) Instead Of Regional Setting

I am trying to create a Table with a field which is in US Dollars.

I am building the database on a computer which is set up with GBP Pounds as the default currency in Regional Settings. The...
Forum: Modules & VBA 06-19-2019, 06:57 AM
Replies: 18
Views: 580
Posted By Cark
Re: Extracting content from an ACCDE Database

Private Sub sAddFleet()

Dim strSql As String

strSql = "Insert into TblFleetSelections(PartID,FleetID) values(" & Parent.PartID & "," & Me.lstAvailable & ")"

'Debug.Print strSql
...
Forum: Modules & VBA 06-18-2019, 10:43 PM
Replies: 18
Views: 580
Posted By Cark
Re: Extracting content from an ACCDE Database

By all means I am happy to consider this approach and I agree it would be nice to avoid the use of a subform.

I just tested the database and ran into a bit of an issue involving the PartID.

It...
Forum: Modules & VBA 06-18-2019, 02:32 AM
Replies: 18
Views: 580
Posted By Cark
Re: Extracting content from an ACCDE Database

Thank you all for your great input.

I am trying to play around with the ListBoxExamples database and have managed to copy the 2 column list w/query rowsource to a 2 column value list into a form...
Forum: Forms 06-18-2019, 12:20 AM
Replies: 6
Views: 247
Posted By Cark
Re: Preventing users from removing attachments from the Attachment Control in a Form

All sounds like really good stuff and I appreciate you breaking down the pros and cons of different approaches. Having multiple approaches to pick from is really useful to me so that I can pick based...
Forum: Modules & VBA 06-13-2019, 11:42 PM
Replies: 18
Views: 580
Posted By Cark
Re: Extracting content from an ACCDE Database

Thank you all for the clarification/advice.

The form for the list box picker on the face of it works relatively simply by taking whatever is selected (multiple selections using ctrl+left click are...
Forum: Modules & VBA 06-13-2019, 01:39 AM
Replies: 18
Views: 580
Posted By Cark
Extracting content from an ACCDE Database

Via my work network, I have access to an old ACCDE Database that someone (who has since left the company) made a very long time ago that has a list box selector with some VBA Code in the background...
Forum: Forms 06-13-2019, 01:32 AM
Replies: 6
Views: 247
Posted By Cark
Re: Preventing users from removing attachments from the Attachment Control in a Form

Hi Mark_,

I had been reading up on attachments and came across the idea of database bloat as you mentioned. Although I don't envisage this particular database reaching the 2gb file size limit, I...
Forum: Tables 06-13-2019, 01:28 AM
Replies: 6
Views: 312
Posted By Cark
Re: Advice needed on Table Layout and Relationships

@theDBguy - - Yes like the first configuration you mentioned. One tab will take down details like Color = Blue and then the other tab will have data that doesn't relate to Color in the slightest e.g...
Forum: Forms 06-12-2019, 07:19 AM
Replies: 6
Views: 247
Posted By Cark
Preventing users from removing attachments from the Attachment Control in a Form

I have an Attachment Control on a Form and would like to modify the way in which it works so that a user cannot accidentally click "Remove" when they are meaning to click "Add...". Is there a way I...
Forum: Tables 06-12-2019, 07:10 AM
Replies: 6
Views: 312
Posted By Cark
Re: Advice needed on Table Layout and Relationships

I read your message almost immediately after you posted the replay, but wanted to just check in Access before replying. Everything seems to be coming together nicely with an individual table for each...
Forum: Tables 06-12-2019, 03:05 AM
Replies: 6
Views: 312
Posted By Cark
Advice needed on Table Layout and Relationships

I have a bit of a peculiar database and form that I am trying to create to store lots of different bits of information in one nice and holistic database. Each Tab has different bits of information...
Forum: Forms 06-12-2019, 12:20 AM
Replies: 2
Views: 97
Posted By Cark
Removing the [Add New] Navigation Button from a Navigation Control

I have been fumbling around with Navigation Controls and Navigation Buttons for a while and have not been able to find a way to get rid of the [Add New] Navigation Button from the Navigation Control....
Forum: Queries 06-07-2019, 05:29 AM
Replies: 9
Views: 196
Posted By Cark
Re: Simple query to calculate totals from 2 different tables

Still working on this, but with no success.
Forum: Modules & VBA 06-04-2019, 08:23 AM
Replies: 12
Views: 441
Posted By Cark
Re: Exporting a graph/chart from Microsoft Access to PDF/JPEG/GIF

Due to the fact I have quite a few OnLoad, OnOpen and OnCurrent events, it causes my screen to flicker when it loads the text boxes and graphs. Is there an alternative workaround to the DoCmd close...
Forum: Queries 06-04-2019, 07:59 AM
Replies: 9
Views: 196
Posted By Cark
Re: Simple query to calculate totals from 2 different tables

I appreciate my tables are pretty confusing. I am trying to think if there is a ready-made data set that I can use to assist with solving this issue.

Does the attached dataset help a bit more?
...
Showing results 1 to 25 of 95

 
Forum Jump



All times are GMT -8. The time now is 07:37 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