Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 131
Search took 0.01 seconds.
Search: Posts Made By: kitty77
Forum: General 11-10-2019, 09:16 AM
Replies: 12
Views: 140
Posted By kitty77
Re: VBA Text

I don't see anything in the table design where you change text format?
Forum: General 11-10-2019, 08:59 AM
Replies: 12
Views: 140
Posted By kitty77
Re: VBA Text

Looks like it only works on unbound fields?
Forum: General 11-10-2019, 08:58 AM
Replies: 12
Views: 140
Posted By kitty77
Re: VBA Text

Yes, it is the same as yours. Same error on a report or form.
Also, tried it on different text fields. I get the same error?
Forum: General 11-10-2019, 08:44 AM
Replies: 12
Views: 140
Posted By kitty77
Re: VBA Text

When I change the settings to rich, I get an error.

The setting you entered isn't valid for the property.
Forum: General 11-10-2019, 08:27 AM
Replies: 12
Views: 140
Posted By kitty77
Re: VBA Text

Where do I set it to rich? Can you give me an example?
Forum: General 11-10-2019, 08:18 AM
Replies: 12
Views: 140
Posted By kitty77
Re: VBA Text

On a report
Forum: General 11-10-2019, 05:54 AM
Replies: 12
Views: 140
Posted By kitty77
VBA Text

Is it possible to change the font, bold, etc... in vba?

[Field1] = "Apple" & vbCrLf & "Blue" & vbCrLf & "Red"

How can I make "Blue" bold or Italic only?

Thanks...
Forum: General 11-08-2019, 04:59 AM
Replies: 2
Views: 73
Posted By kitty77
Count and Average

How can I count the records for each day (by date) and then get an average for each day? What is the best way?

Thanks...
Forum: General 11-06-2019, 06:16 AM
Replies: 7
Views: 105
Posted By kitty77
Re: Query and another field

So, is something like this possible on one line?

"AAA" Or "BBB" Or Iif(isnull([main].[field1]) and [main].[field2] = "CCC")
Forum: General 11-06-2019, 05:25 AM
Replies: 7
Views: 105
Posted By kitty77
Re: Query and another field

I'm trying something like this... but I'm sure I'm missing something.

"AAA" Or "BBB" Or Iif(isnull([main].[field1]) and [main].[field2] = "CCC")
Forum: General 11-06-2019, 05:05 AM
Replies: 7
Views: 105
Posted By kitty77
Query and another field

How can I do the following...

I have a query that brings back records with "aaa" or "bbb"
How can I get records with "aaa" or "bbb" and only are null from another field?

So, need "bbb" and...
Forum: General 11-05-2019, 09:25 PM
Replies: 4
Views: 139
Posted By kitty77
Re: Duplicate that are empty

The query was created using the wizard to find duplicates. I would have to extract the records that are be returned as duplicates. May take some time...
Forum: General 11-05-2019, 09:16 PM
Replies: 5
Views: 146
Posted By kitty77
Re: Combine fields from different tables

Getting an error... The specified field could refer to more than one table listed in the FROM clause in your SQL statement...
Forum: General 11-05-2019, 08:57 PM
Replies: 5
Views: 146
Posted By kitty77
Re: Combine fields from different tables

No. I want to have the two fields be in one column instead of two.
Or an IF statement... If field1 is empty, then use Field2.

Hope that makes sense...
Forum: General 11-05-2019, 08:31 PM
Replies: 5
Views: 146
Posted By kitty77
Combine fields from different tables

I have a query made up of three tables. Field1 is from table A and Field2 is from table B. How can I create an expr that would put the values into one column? So, I don't have to have individual...
Forum: General 11-05-2019, 08:27 PM
Replies: 4
Views: 139
Posted By kitty77
Duplicate that are empty

I created a find duplicates on a field. It brings back duplicates like you would imagine but it also brings back duplicates with no value in the field? Very strange... About 10 records in a table...
Forum: General 11-03-2019, 07:33 PM
Replies: 16
Views: 228
Posted By kitty77
Re: change record source on a report

I think I will take your advice and keep it together in one table. Might solve a few other issues going forward... Thanks!
Forum: General 11-03-2019, 07:16 PM
Replies: 16
Views: 228
Posted By kitty77
Re: change record source on a report

That me be so... but just something I've done for a long time, keeping it separate.
Forum: General 11-03-2019, 06:55 PM
Replies: 16
Views: 228
Posted By kitty77
Re: change record source on a report

They are completed records and keeping them in a separate table is best for me. When the history table get large, I would then move the table to another database. You're not prying...
Forum: General 11-03-2019, 06:46 PM
Replies: 16
Views: 228
Posted By kitty77
Re: change record source on a report

Not many... 3000 records. Master is my active data and History is an achieve table. I like to keep them separate. But from time to time I need a report based on the history and I need a way to...
Forum: General 11-03-2019, 06:35 PM
Replies: 16
Views: 228
Posted By kitty77
Re: change record source on a report

That is correct. I have a master table and a history table. Same structure.
Forum: General 11-03-2019, 04:44 PM
Replies: 16
Views: 228
Posted By kitty77
Re: change record source on a report

I'm getting an error... You entered an expression that has no value.

DoCmd.OpenReport strDocName, acViewReport, , strWhere, , "Masterhistory"
Forum: General 11-03-2019, 04:32 PM
Replies: 16
Views: 228
Posted By kitty77
Re: change record source on a report

I'm using this... but format of the last line must not be correct.

Dim strDocName As String
strDocName = "ABC"
Dim strWhere As String
strWhere = "[Mrecordid]=" & Me!Mrecordid
DoCmd.OpenReport...
Forum: General 11-03-2019, 03:43 PM
Replies: 16
Views: 228
Posted By kitty77
change record source on a report

I have a form that opens up a report for that record number. How can I make that report use a different record source? I have a lot of reports and do not want to create new ones based on another...
Forum: General 10-29-2019, 06:05 PM
Replies: 4
Views: 144
Posted By kitty77
Re: AllowEdits

That did it! Thanks!!
Showing results 1 to 25 of 131

 
Forum Jump



All times are GMT -8. The time now is 05:23 AM.


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