Activity Stream - Microsoft Access Forums

Sort By	Time	Show
Recent Recent Popular Popular	Anytime Anytime Last 7 Days Last 7 Days Last 30 Days Last 30 Days	All All Photos Photos Forum Forums Groups Groups

Today, 02:56 AM

ahmad_3011 replied to a thread Comparing Promotion Requirements with courses in Access

Hi Dal, Does it make any different to put the promotion requirement in a sub form like the attachment?

15 replies | 103 view(s)

Today, 02:37 AM

harris71 started a thread Query that excludes records with no 'children' in Queries

Hello, I'm relatively new access, and I have the following question: I have two tables in my database, the 'sentence' table and the 'word'...

0 replies | 2 view(s)

Today, 01:20 AM

asoe209 replied to a thread Design help for item location and testing date database in Database Design

Morning, thanks for the reply. Sorry for got to attach file but i cant attach from work pc. will have to attach later Well I keep tryinig and...

2 replies | 37 view(s)

Today, 12:39 AM

ahmad_3011 replied to a thread Comparing Promotion Requirements with courses in Access

Hi Dal, in the system I use is like Recruitment systems the employee has many courses the promotion is like a suggested company so when I chose...

15 replies | 103 view(s)

Today, 12:14 AM

June7 replied to a thread combo box/subform limit in Forms

This concerns the combobox in the subform on the Comms Tracking tab? Options: 1. create the set of five records all at one time and instead of...

5 replies | 30 view(s)

Yesterday, 11:58 PM

kris9 replied to a thread combo box/subform limit in Forms

sent you pm. Form is tblUsers

5 replies | 30 view(s)

Yesterday, 11:42 PM

June7 replied to a thread combo box/subform limit in Forms

What form is involved in issue?

5 replies | 30 view(s)

Yesterday, 11:34 PM

kris9 replied to a thread combo box/subform limit in Forms

hi, sent you PM

5 replies | 30 view(s)

Yesterday, 11:32 PM

June7 replied to a thread Parameter Value Issue from Search ComboBox in Forms

The query already has a 'Where' expression - it is the criteria referencing the combobox. Open the query in SQL View and you will see the various...

1 replies | 11 view(s)

Yesterday, 11:07 PM

June7 replied to a thread combo box/subform limit in Forms

What is the source of the combobox options - a table or value list? Want to provide db for analysis? Follow instructions at bottom of my post.

5 replies | 30 view(s)

Yesterday, 11:05 PM

June7 replied to a thread checklist in Forms

Want to provide db for analysis? Follow instructions at bottom of my post.

16 replies | 136 view(s)

Yesterday, 10:21 PM

amrut replied to a thread Tab - Form->subform in Forms

This link should be helpful.

1 replies | 14 view(s)

Yesterday, 10:08 PM

masoud_sedighy replied to a thread How to fill level 3 of treeview in Programming

Yes I assume a Bookid can have have two different authors. Also I assume a Transid can have two different books. And design of my tables...

6 replies | 39 view(s)

Yesterday, 09:47 PM

kris9 started a thread Tab - Form->subform in Forms

Hi, I have a main form and multiple subforms(within different tabs). How do I Tab from main form fields to each subform fields ? Using...

1 replies | 14 view(s)

Yesterday, 09:46 PM

kris9 started a thread combo box/subform limit in Forms

I have a combo box with 5 options within a subform - Continuous Forms view. Option within a combo box is selected and select date for it. After...

5 replies | 30 view(s)

Yesterday, 09:40 PM

CNW replied to a thread Setfocus from split form to main form in Forms

I have found a workable solution to issue. This form is based on multiple tabs. By putting an OnClick event in each field of the splitform I can...

5 replies | 203 view(s)

Yesterday, 08:41 PM

RuralGuy replied to a thread Building An Expression Help in Access

Additional note, the code offered does not precisely match what you said.

8 replies | 49 view(s)

Yesterday, 08:39 PM

RuralGuy replied to a thread Building An Expression Help in Access

Try: Last Exam Start Date Up: IIf(.=0, Nz(,"00-00-0000"), "")) Warning: Air code, not tested!! FYI: It is not a good idea to have embedded...

8 replies | 49 view(s)

Yesterday, 08:39 PM

russb started a thread How to edit MS Access tables via web in Access

Hi I have an MS Access 2007 desktop database that has been in use for many years. Of the numerous tables, I have three tables that now require...

0 replies | 13 view(s)

Yesterday, 08:17 PM

slimjen replied to a thread checklist in Forms

Ok. It worked but only if I checked all the boxes. This defeats the purpose if there are "No" answers. And it didn't save the check marks once the...

16 replies | 136 view(s)

Yesterday, 08:13 PM

pjd71 started a thread Parameter Value Issue from Search ComboBox in Forms

I have searched and searched for a solution to my problem of opening a Query without having the form open first. The "Enter Parameter Value" started...

1 replies | 11 view(s)

Yesterday, 08:13 PM

JoeM replied to a thread creating relationships cause data to not show.. in Queries

I wonder if adding in an extra set of parentheses may help to the code in my last post will help, i.e. SELECT Accounts.ClientID, Accounts.ProductID,...

14 replies | 80 view(s)

Yesterday, 08:05 PM

JoeM replied to a thread How can i clear a query with vba or macro? in Access

After you clear all of your Form values, you may need to refresh the query with a statement like: Me.Refresh Also, what are you trying to do by...

7 replies | 68 view(s)

Yesterday, 08:04 PM

June7 replied to a thread Select Query - Top Values Plus "All Else" in Queries

Possibly your former co-worker did one query for the top10, another query for everything not in the top 10, then combined the two with UNION query.

1 replies | 24 view(s)

Yesterday, 07:57 PM

June7 replied to a thread Design help for item location and testing date database in Database Design

Not seeing an attachment to your post. Maintenance and inventory type databases have been discussed. Did you search forum? or Google? What you...

2 replies | 37 view(s)

Yesterday, 07:52 PM

Missinglinq replied to a thread Combobox to open a form to selected record in Forms

I believe that Combo49] needs to be replaced with the name of the Field that Combo49] is Bound to, in the second Form. Linq ;0)>

3 replies | 25 view(s)

Yesterday, 07:52 PM

June7 replied to a thread URGENT HELP NEEDED on building my access database. ;WILL REWARD in Access

The database appears not to be in a normalized structure. What you want can probably be done, but not easily. If you want to provide db for analysis,...

1 replies | 15 view(s)

Yesterday, 07:50 PM

dccjr replied to a thread Clearing a range of cell in Excel from Access VBA in Programming

I use a table to export to Excel for charting purposes. Each time the user runs a new chart, I typically clear the sheet with the code above before...

4 replies | 37 view(s)

Yesterday, 07:46 PM

June7 replied to a thread Add a Text Box to a Report Showing the Result of an Unrelated Query in Reports

Could try domain aggregate function. I don't know the structure of the 2012 query but maybe like: =DCount("*", "queryname")

1 replies | 20 view(s)

Yesterday, 07:40 PM

June7 replied to a thread Migration from Access 2003 on XP to Access 2007/2010 on Win7 in Access

What is AD environment? This shows how to manually find the last accessed date/time of any application on a computer. How to automate this to hit...

1 replies | 23 view(s)