Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 149
Search took 0.03 seconds.
Search: Posts Made By: kitty77
Forum: General 01-16-2020, 10:13 AM
Replies: 2
Views: 108
Posted By kitty77
duplicate record

I have a form that has a command button that duplicates the record. I use it for labels and things... I have to push the button the amount of times I need.

How can I make something ask me how...
Forum: General 01-15-2020, 07:49 AM
Replies: 3
Views: 158
Posted By kitty77
Re: Search Key Not Found

In a specific field? Or all fields?

How can I find them?
Forum: General 01-15-2020, 07:40 AM
Replies: 3
Views: 158
Posted By kitty77
Search Key Not Found

Every once in awhile I get the following error...

Microsoft Visual Basic
Run-time error '3709':
The search key was not found in any record.

This happens when I click a command button that is...
Forum: General 01-04-2020, 06:32 PM
Replies: 12
Views: 316
Posted By kitty77
Re: Not IsNull, IsNull

So, how would I combine these...

If Not IsNull([customer]) Or If [customer]<>"" then...

And this one too...

If IsNull([customer]) Or If [customer]=""

Would those work?
Forum: General 01-04-2020, 06:04 AM
Replies: 12
Views: 316
Posted By kitty77
Not IsNull, IsNull

I'm using the following...

If Not IsNull([customer]) then...
If [customer]<>"" then...

I'm assuming these do the same. But they seem to work sometimes, or one or the other.

If...
Forum: General 01-01-2020, 03:36 PM
Replies: 8
Views: 144
Posted By kitty77
Re: copy values to another table

Sure... I have an input form. Used for data entry.
So, while the on the input form, the user will simply click a button that would send that info in those fields to the table.

That info is used...
Forum: General 01-01-2020, 09:34 AM
Replies: 8
Views: 144
Posted By kitty77
copy values to another table

I have a form that has four fields on it. I would like to take those four field values and add them to another record in another table. Would like to use a command button. What is the best...
Forum: General 12-29-2019, 05:33 AM
Replies: 6
Views: 157
Posted By kitty77
Not IsNull

I'm working with the following...
If Not IsNull([test]) Then MsgBox "testing 123"

It does not seem to be working. Some records that are blank or empty or null show the MsgBox.

How can I...
Forum: General 12-27-2019, 05:17 PM
Replies: 5
Views: 128
Posted By kitty77
Re: Append Query Duplicates

Can you provide me an example of the unmatched query with an append?
Forum: General 12-27-2019, 12:54 PM
Replies: 5
Views: 128
Posted By kitty77
Append Query Duplicates

How can I make my append query not append records that are all ready there? Based on a id number. Each record has a unique id number that gets enter. Its kind of a tracking number. but I don't...
Forum: General 12-24-2019, 04:46 PM
Replies: 5
Views: 142
Posted By kitty77
Re: value from another table

I'm trying to get that value from another table into my form based on a value in a field. So, if the value exists in both table, then get the info from a field and paste it in.
Forum: General 12-24-2019, 04:21 PM
Replies: 5
Views: 142
Posted By kitty77
Re: value from another table

Ok, the form is called main based on a table called master.
The field where I want the data pasted is called results.
Bothe tables have a field called sampleid
The table where I want the data to...
Forum: General 12-24-2019, 04:09 PM
Replies: 5
Views: 142
Posted By kitty77
value from another table

I have a form that I would like to click a command button and have the value of a field (in another table) pasted into the field.

if two other fields are equal.

Not sure how to do this. ...
Forum: General 11-18-2019, 07:45 PM
Replies: 24
Views: 408
Posted By kitty77
Re: Duplicates that have no value

Ok, so once I find the records with "" how do I fix or change them to null?
Forum: General 11-18-2019, 06:49 PM
Replies: 24
Views: 408
Posted By kitty77
Re: Duplicates that have no value

I would like to clean up the data but not sure how? Is there a way to show "" vs null or blank?
Forum: General 11-18-2019, 06:17 PM
Replies: 24
Views: 408
Posted By kitty77
Re: Duplicates that have no value

So, how to create a query that checks for real duplicates and the "null"

This is what I have using the duplicate wizard...

In (SELECT [Msamplenumber1] FROM [Main] As Tmp GROUP BY...
Forum: General 11-18-2019, 06:01 AM
Replies: 24
Views: 408
Posted By kitty77
Re: Duplicates that have no value

Ok, I created a select query with "" for that field and sure enough, it returned the same records that the duplicate query found.

But when I look at those records, no value is in it?

So, what...
Forum: General 11-17-2019, 08:11 PM
Replies: 24
Views: 408
Posted By kitty77
Duplicates that have no value

I created a query "Find Duplicates" with the wizard.
It finds duplicates, exactly what I'm looking for but it also finds duplicates for records that have no value in that field. Not sure why it...
Forum: General 11-10-2019, 09:16 AM
Replies: 12
Views: 161
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: 161
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: 161
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: 161
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: 161
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: 161
Posted By kitty77
Re: VBA Text

On a report
Forum: General 11-10-2019, 05:54 AM
Replies: 12
Views: 161
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...
Showing results 1 to 25 of 149

 
Forum Jump



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