Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.19 seconds.
Search: Posts Made By: June7
Forum: Forms Yesterday, 03:38 PM
Replies: 5
Views: 118
Posted By June7
Re: Conditional Formation

Use Conditional Formatting in form or report design. https://www.techonthenet.com/access/forms/cond_format.php

Only textboxes and comboboxes can use CF.
Forum: Forms Yesterday, 03:21 PM
Replies: 4
Views: 96
Posted By June7
Re: Converting Database to French

Cross-posted https://www.utteraccess.com/forum/index.php?showtopic=2051896&st=0&gopid=2705145&#entry2705145
Forum: Modules & VBA Yesterday, 10:59 AM
Replies: 2
Views: 122
Posted By June7
Re: Saving all data to an Access Table using ADODB

Normally I would suggest INSERT SELECT: CurrentDb.Execute "INSERT INTO tablename SELECT …"

But I am not familiar with working with SQLServer backend.

How many fields are involved? - too hard to...
Forum: General 12-14-2018, 11:09 PM
Replies: 7
Views: 155
Posted By June7
Re: Attachments from Outlook automatically saved for use in Access database

So you don't really need to download Outlook attachment, you already have the file saved? Always the same folder location? You copy the new file and write over the Backlog.xlsx file? Do you delete...
Forum: General 12-13-2018, 10:16 PM
Replies: 2
Views: 155
Posted By June7
Re: Export To Pdf And Copy To Clipboard?

Cross-post https://www.utteraccess.com/forum/index.php?showtopic=2051878&hl=

A file cannot be deleted and still be retained on clipboard. Try it manually, I did. Won't work. The clipboard is...
Forum: Modules & VBA 12-13-2018, 12:41 PM
Replies: 7
Views: 252
Posted By June7
Re: TextBox as a Sub parameter

Please post lengthy code between CODE tags to retain indentation and readability.

Textbox is not in a subform? Is it bound to field?
Forum: General 12-13-2018, 10:48 AM
Replies: 9
Views: 171
Posted By June7
Re: Query Two Tables with Different Fields

You 'line up' the similar fields from each table. If a table does not have field equivalent to other table, use Null as a 'placeholder'. Review https://www.w3schools.com/sql/sql_union.asp
Forum: General 12-13-2018, 10:44 AM
Replies: 7
Views: 155
Posted By June7
Re: Attachments from Outlook automatically saved for use in Access database

Might find this discussion interesting https://access-programmers.co.uk/forums/showthread.php?t=302556
Forum: Queries 12-13-2018, 12:38 AM
Replies: 10
Views: 489
Posted By June7
Re: My query doesn't work

Well, if both fields have data then the expression should work. I don't see anything wrong with the syntax. I would suggest posting db so we could analyze but if it is all in Spanish that could be...
Forum: Modules & VBA 12-12-2018, 11:01 PM
Replies: 11
Views: 262
Posted By June7
Re: open record from union query

You have a form based on UNION query? You select record on that form and want to open another form based on UNION form record?

A field could be built in the UNION query that provides the...
Forum: General 12-12-2018, 06:24 PM
Replies: 7
Views: 155
Posted By June7
Re: Attachments from Outlook automatically saved for use in Access database

I think you have to use VBA code in Outlook or Access to download the files from Outlook folder to your system folder.
Forum: General 12-12-2018, 11:58 AM
Replies: 9
Views: 171
Posted By June7
Re: Query Two Tables with Different Fields

Sounds like you need a UNION query. Example:

SELECT ID, field1 AS Name1, field2 AS Name2, Null AS Name3, "T1" AS Source FROM table1
UNION SELECT ID, field1, Null, field3, "T2" FROM table2;

The...
Forum: Excel 12-12-2018, 10:31 AM
Replies: 18
Views: 1,830
Posted By June7
Re: Find Cell Value. and perform Loop

Both versions of code open a recordset of Order Numbers where E is x. Then looping through the recordset first method looks for match on each row to the Order Number in the recordset and sets E to x...
Forum: Excel 12-12-2018, 01:00 AM
Replies: 18
Views: 1,830
Posted By June7
Re: Find Cell Value. and perform Loop

I use Win 10 and Office 2010. The code works. I even edited my post with another variation.


x.x represents the version number. You should choose 6.1


Otherwise, try late binding.

Dim...
Forum: Excel 12-12-2018, 12:09 AM
Replies: 18
Views: 1,830
Posted By June7
Re: Find Cell Value. and perform Loop

Okay, here's what I did. In VBA Editor, set Reference to Microsoft ActiveX Data Objects x.x Library because code is using early binding.

Sub setX()
Dim rst As New ADODB.Recordset
Dim cnx As New...
Forum: Excel 12-11-2018, 10:12 PM
Replies: 18
Views: 1,830
Posted By June7
Re: Find Cell Value. and perform Loop

I have the file. Not clear to me what you actually want to happen. The worksheet structure doesn't seem to agree with description in original post. Column D does not have "X", Column E does. And X is...
Forum: Modules & VBA 12-11-2018, 09:46 PM
Replies: 11
Views: 378
Posted By June7
Re: Detect which column

Sorry, I missed that you want to reference a subform. Where do you want to run the code? Eugene's suggestion works for me.

objSubForm should replace "Your object sub form"

Post your code.
Forum: Forms 12-11-2018, 04:00 PM
Replies: 4
Views: 250
Posted By June7
Re: Text Box - Control Source

Use Date() instead of Now().

Cannot directly reference table in expression. Can only reference fields that are included in the form's RecordSource. Options are:

1. include List_Trainings in the...
Forum: Modules & VBA 12-11-2018, 03:51 PM
Replies: 11
Views: 378
Posted By June7
Re: Detect which column

Try.
Forms![your form name].ActiveControl.Name

or

Screen.ActiveControl.Name

https://docs.microsoft.com/en-us/previous-versions/office/developer/office-2003/aa223188(v=office.11)

I...
Forum: Excel 12-11-2018, 03:31 PM
Replies: 18
Views: 1,830
Posted By June7
Re: Find Cell Value. and perform Loop

Not clear to me what issue is. Does the code error, produce wrong results, do nothing?

Is Value2 a valid property?

Could you provide your file? Follow instructions at bottom of my post.
Forum: Queries 12-11-2018, 02:08 PM
Replies: 13
Views: 430
Posted By June7
Re: Absence Calendar

Don't know, it works perfect for me.
Forum: Tables 12-11-2018, 01:25 PM
Replies: 27
Views: 1,689
Posted By June7
Re: Calculated field

Latitude and longitude in decimal should be number (double) type fields. There are no letters in these values. A decimal point is part of a number.

I used to work for state DOT and also had to...
Forum: Forms 12-11-2018, 12:58 PM
Replies: 15
Views: 589
Posted By June7
Re: Intermitttent - "You can't assign a value..", with a bound checkbox

Work flow allows multiple users to edit same record at same time?

If you want to provide db for analysis, follow instructions at bottom of my post.
Forum: Queries 12-11-2018, 12:51 PM
Replies: 13
Views: 430
Posted By June7
Re: Absence Calendar

@isladogs, forgot the link to Peter Hibbs

Example in post 6 uses a table with date range fields.
Forum: Queries 12-11-2018, 12:21 PM
Replies: 13
Views: 430
Posted By June7
Re: Absence Calendar

I didn't look at isladogs db but here is another. Absence records use date range, code manipulates this info to generate records in a 'temp' table that is used as the report RecordSource.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 08:29 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 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World