Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 33
Search took 0.04 seconds.
Search: Posts Made By: access17401
Forum: Queries 01-10-2018, 04:30 PM
Replies: 5
Views: 1,275
Posted By access17401
Re: Update Query

So i tried to implement the above code this morning as part of the update query and i receive this error = the expression you entered contains invalid syntax, without a corresponding operand, any...
Forum: Queries 01-09-2018, 07:00 PM
Replies: 5
Views: 1,275
Posted By access17401
Re: Update Query

They are joined, so that's perfect. I won't be able to test it until tmrw but was eager to see.

I guess my skills are improving, even if its a little bit
Forum: Queries 01-09-2018, 06:29 PM
Replies: 5
Views: 1,275
Posted By access17401
Update Query

I have an update query amending information, from tblver to tbltan in the query I want to add something but am not sure if it will work, or if i have the right code.

The field i want to update =...
Forum: General 01-08-2018, 03:59 PM
Replies: 3
[SOLVED] Database issue
Views: 538
Posted By access17401
Re: Database issue

Thanks pbaldy, I had a look into that and it was fine.

I did some more googling and not being a trusted document came up, which ended up being the issue even though there was nothing anywhere in...
Forum: General 01-08-2018, 03:39 PM
Replies: 3
[SOLVED] Database issue
Views: 538
Posted By access17401
Database issue

Morning Everyone,

I have a database, that we have been using at work and it has been running beautifully for 3 months now.

For various reasons I have had to create a new user account for myself...
Forum: Forms 11-14-2017, 05:33 PM
Replies: 15
Views: 1,240
Posted By access17401
Re: Change text input

Ow ok that's perfect thanks ridders.

Though no point in asking for help, if I don't learn and understand why.

Appreciate the explanation
Forum: Forms 11-14-2017, 04:40 PM
Replies: 15
Views: 1,240
Posted By access17401
Re: Change text input

Thanks arnelgp, I was close. So I understand why is the 'Right' in the line 'strToken = Left(Right(Me.txtString, 6), 2)' is that what changes it to read from the right?

I think when I was trying...
Forum: Forms 11-09-2017, 04:12 PM
Replies: 15
Views: 1,240
Posted By access17401
Re: Change text input

Hi guys can the answer provided by Mark be altered. To change text in the MIDDLE of a field IF the only constant in the field is the number after the text that needs changing

eg.

Could be...
Forum: Forms 10-30-2017, 07:58 PM
Replies: 15
Views: 1,240
Posted By access17401
Re: Change text input

Wow thanks for the response, i really did have one of those moments.

Unfortunately ridders nothing that exciting, basically warm and cold. Unfortunately the last couple (really my first couple)...
Forum: Forms 10-30-2017, 03:42 PM
Replies: 15
Views: 1,240
Posted By access17401
Change text input

I think I am having a rough morning, searched the web and haven't found anything (but to be honest drawing a blank on the wording of what to search)

We have a data entry form, its high use...
Forum: Queries 10-12-2017, 05:33 PM
Replies: 11
Views: 2,548
Posted By access17401
Re: Using Text box as search function

Sorted it out thanks for the pointers Mark, works perfect
Forum: Queries 10-12-2017, 04:11 PM
Replies: 11
Views: 2,548
Posted By access17401
Re: Using Text box as search function

Not sure about the brackets, they weren't there, I should of checked after i pasted the code in.

The fields are there, i only use txt. for the field names as that is the suggestion i received when...
Forum: Queries 10-12-2017, 03:39 PM
Replies: 11
Views: 2,548
Posted By access17401
Re: Using Text box as search function

I have implemented example as suggested thanks.

I did have a thought though, just in the interest of learning I tried using Dlookup. Would this work?

I have received error 2465, it might be in...
Forum: Queries 10-11-2017, 03:58 PM
Replies: 11
Views: 2,548
Posted By access17401
Re: Using Text box as search function

I do understand that, for most of the records we will input in this database the user will scan in the URN and then scan in AppealID via barcodes, the year field that i am aiming to populate is...
Forum: Queries 10-11-2017, 03:31 AM
Replies: 11
Views: 2,548
Posted By access17401
Re: Using Text box as search function

Thanks I have seen the combo method through my research. I just think I should be able to find a way to do it through 2 text boxes.

So say I have a table which is three columns AppealID, URN and...
Forum: Queries 10-10-2017, 05:17 PM
Replies: 11
Views: 2,548
Posted By access17401
Using Text box as search function

Good morning,

I have created a search function using a text box and command button bellow. This searches and returns from table according to the URN.

Private Sub Command200_Click()
If...
Forum: Queries 09-27-2017, 06:07 PM
Replies: 6
Views: 740
Posted By access17401
Order by in UNION Query

I have a union query below, it combines three queries. I want the output to show results in order, so all of first query results, all of second query results and then all of third query results. I...
Forum: Queries 09-18-2017, 05:06 PM
Replies: 4
[SOLVED] Export Query
Views: 408
Posted By access17401
Re: Export Query

Sorry just thought of something else, the current file exports the data but without the headings is there a way to add in the table headings?
Forum: Queries 09-14-2017, 02:25 PM
Replies: 4
[SOLVED] Export Query
Views: 408
Posted By access17401
Re: Export Query

Both worked perfectly, thanks
Forum: Forms 09-13-2017, 10:14 PM
Replies: 9
Views: 510
Posted By access17401
Re: Creating Salutation Rules

For anyone who may need the help in the future this is the code that worked:

Private Sub ADP_Firstname_AfterUpdate()
' Telling it that is firstname is more then 2 characters use first name...
Forum: Queries 09-13-2017, 10:12 PM
Replies: 4
[SOLVED] Export Query
Views: 408
Posted By access17401
Export Query

Afternoon

I have made a query called "NAB Export Query", to send out a text file.
I have then created a command button on a form to run the export, with the following code:

Private Sub...
Forum: Forms 09-13-2017, 09:30 PM
Replies: 9
Views: 510
Posted By access17401
Re: Creating Salutation Rules

You sir are a legend, finished, sorted and working. Plus I have got the override sorted. Thank you.
Forum: Forms 09-13-2017, 08:26 PM
Replies: 9
Views: 510
Posted By access17401
Re: Creating Salutation Rules

Cool well i nearly have it (changed field names in my form)

Private Sub ADP_Title_AfterUpdate()
' Telling it that is firstname is more then 2 characters use first name
If...
Forum: Forms 09-13-2017, 07:30 PM
Replies: 9
Views: 510
Posted By access17401
Re: Creating Salutation Rules

Ok so this is what i have so far, please be kind only been writing code for two weeks, I am a very basic and early learning but trying really hard.

Private Sub Form_AfterUpdate()
' Telling it...
Forum: Forms 09-12-2017, 03:14 PM
Replies: 9
Views: 510
Posted By access17401
Creating Salutation Rules

So I have a complicated question (it’s probable not that hard but I am struggling), I have the following fields.

A_Title – Title, data input
A_FirstName – First name, data input
A_MiddleName –...
Showing results 1 to 25 of 33

 
Forum Jump



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