Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.06 seconds.
Search: Posts Made By: MickJav
Forum: General 11-27-2019, 01:51 PM
Replies: 8
Views: 244
Posted By MickJav
Re: Test/dev and production environment

Seems to me they want him to start using diffierent files I.E.

Development
Testing
Production

these would be 3 different versions the production being the one everybody uses
the testing may...
Forum: Introduce Yourself 11-26-2019, 12:19 PM
Replies: 8
Views: 179
Posted By MickJav
Re: Access is the Best!

I use office 365 and pay a monthly subscription which I think is good value for money as I get updates and 1tb of one drive space until this query error I was really happy.


I would still need...
Forum: Forms 11-24-2019, 11:56 AM
Replies: 3
Views: 97
Posted By MickJav
Re: Copy Value to Form

You could try copying to the clip board I have used that in my Style Manager look at the button Code by the colour boxes


https://databasedreams.createaforum.com/style-manager/
Forum: The Watercooler 11-24-2019, 11:06 AM
Replies: 16
Views: 379
Posted By MickJav
Re: why do Access developers give away so much for free?

Me I use a program I spent years building works a charm for all the above and includes a lot of help from members of different sites I am going to create a version soon for everybody to use should...
Forum: The Watercooler 11-24-2019, 09:05 AM
Replies: 16
Views: 379
Posted By MickJav
Re: why do Access developers give away so much for free?

I've only just started updating them due to the accsss Query Error but I don't expect to get much if anything.


my forums a free one and only costs if I need more space but I have limited who can...
Forum: The Watercooler 11-24-2019, 08:50 AM
Replies: 16
Views: 379
Posted By MickJav
Re: why do Access developers give away so much for free?

I work with access as a hobby and to help others I develope open code and accde files but all are free to use without limitations.


I used to run a business as an electrician which I did for a...
Forum: Queries 11-23-2019, 04:23 AM
Replies: 58
Views: 1,882
Posted By MickJav
Re: Access error -query is corrupt

Thanks for the info I've had to update 3 projects with this error plus my Employee Example has the problem but most users are developers who should be able to fix it with the info you provided.
Forum: Queries 11-19-2019, 03:58 PM
Replies: 17
Views: 319
Posted By MickJav
Re: Undefined function 'Nz' in expression

I just built a complex query where I have a couple of nz() functions think I have the latest update the one with the query corrupt error havnt had a problem with the 2.5 mill dataset
Forum: General 11-15-2019, 12:25 PM
Replies: 48
Views: 687
Posted By MickJav
Re: Closing a Form after Validation

What I normally do is if all tests are passed the return true if not false then in the button test for that.


You will need to update your function like
Public Function ValidationOfControl() As...
Forum: General 11-15-2019, 10:16 AM
Replies: 37
Views: 706
Posted By MickJav
Re: Useful links

Always make sure you backup every day or more depending how much work you've done I backup off site once a day and sometimes more so if something does happen I can recover.


Also be careful where...
Forum: Small Business 11-14-2019, 02:40 PM
Replies: 1
Views: 160
Posted By MickJav
Image designer needed

I require an image designer for as and when required works this will be a very small amount of work like building images for splash screens and some button images please contact me should you be...
Forum: The Watercooler 11-11-2019, 11:42 PM
Replies: 6
Views: 179
Posted By MickJav
Re: from version 1992 to version 2016

Same here no inteli sence made things interesting lol
Forum: Tables 11-10-2019, 11:45 PM
Replies: 11
Views: 224
Posted By MickJav
Re: Design of table structures

But most of us enjoy ready you posts they are always full of goodness lol
Forum: Tables 11-10-2019, 03:21 PM
Replies: 11
Views: 224
Posted By MickJav
Re: Design of table structures

Sorry dont really agree with that in my view the first thing you should do is write down what you think you'll need for tables, fields relationships then you can start playing with form and queries...
Forum: The Watercooler 11-10-2019, 04:19 AM
Replies: 21
Views: 408
Posted By MickJav
Re: what's your most complex VBA code project?

I built a program back in 2000 called chart tracker Elite which have a number of import/exort moduals

This was what the output looked like...
Forum: Forms 11-03-2019, 12:44 PM
Replies: 13
Views: 231
Posted By MickJav
Re: Tab Control Detail Back Color

Just had a look and it seems to only do the colours What I'm working on does effects and colours but it does have one draw back here:...
Forum: Forms 11-03-2019, 12:26 PM
Replies: 13
Views: 231
Posted By MickJav
Re: Tab Control Detail Back Color

Thanks I'll have a look but going to finish mine as got this far and no fun in using somebody else's lol
Forum: Forms 11-03-2019, 07:55 AM
Replies: 13
Views: 231
Posted By MickJav
Re: Tab Control Detail Back Color

No I used one from total visual sourcebook and altered it so it saved the list to a table.
Forum: Forms 11-03-2019, 06:53 AM
Replies: 13
Views: 231
Posted By MickJav
Re: Tab Control Detail Back Color

Going Good It looks like a splash of colours and settings but just been playing so I can see how each control type reacts to different settings.


I was originally designing it for a project I'm...
Forum: Forms 11-03-2019, 12:27 AM
Replies: 13
Views: 231
Posted By MickJav
Re: Tab Control Detail Back Color

Thanks will do


Worked a treat many thanks TheDbGuy


mick
Forum: Forms 11-02-2019, 03:08 PM
Replies: 13
Views: 231
Posted By MickJav
Re: Tab Control Detail Back Color

A long like 2345654
Forum: Forms 11-02-2019, 02:06 PM
Replies: 13
Views: 231
Posted By MickJav
Re: Tab Control Detail Back Color

Your right I was clicking in centre and didn't think it was showing the form detail section lol must have been one of them moments lol


but still can't set the back colour even with

...
Forum: Forms 11-02-2019, 01:49 PM
Replies: 13
Views: 231
Posted By MickJav
Tab Control Detail Back Color

Hi All


I'm building an example https://databasedreams.createaforum.com/style-manager/
(https://databasedreams.createaforum.com/style-manager/)


I have 80% done but having no end trouble...
Forum: Reports 10-25-2019, 04:10 PM
Replies: 4
Views: 144
Posted By MickJav
Re: report time sort order

You need to use Sorting and grouping add a sort order on your date field.


mick
Forum: Queries 10-22-2019, 10:38 PM
Replies: 5
Views: 125
Posted By MickJav
Re: Show all Records

You still dont need two tables it's a works system have a look at the works manager tables on my site use link in my sig you can get all the information from queries

Mick
Showing results 1 to 25 of 500

 
Forum Jump



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