Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 64
Search took 0.17 seconds.
Search: Posts Made By: kimberlin
Forum: General 07-20-2016, 06:27 AM
Replies: 8
Views: 445
Posted By kimberlin
Re: work database - possibly needs changing from attachment to hyperlink

Thanks Minty, as soon as the boss gets back from leave next week I will mention it to him again. I did mention in an email to him before he went on leave that maybe we should be thinking in terms of...
Forum: General 07-20-2016, 05:39 AM
Replies: 8
Views: 445
Posted By kimberlin
Re: work database - possibly needs changing from attachment to hyperlink

Thanks for your replies, I have already got auto numbering set on the tables which contain the worker and client details. It's only the form which inputs or edits data to the worker table which would...
Forum: General 07-20-2016, 04:03 AM
Replies: 8
Views: 445
Posted By kimberlin
Re: work database - possibly needs changing from attachment to hyperlink

Thanks for your reply Minty, I am on my own in the office tomorrow so will try the back up as soon as I get in.

At the moment the CVs are kept on the machine of the person who has registered or...
Forum: General 07-20-2016, 01:50 AM
Replies: 8
Views: 445
Posted By kimberlin
work database - possibly needs changing from attachment to hyperlink

I'm hoping someone can offer a bit of advice here. I admit I know nothing about coding but for some reason my boss decided 4 years ago that he wanted me to create an access database using records to...
Forum: Forms 12-12-2012, 06:08 AM
Replies: 0
Views: 296
Posted By kimberlin
Question duplicate names not showing

Hi I received some good help from this site back in the summer when i was landed with having to create a database for use at work. We have been using it with no trouble for a few months now but...
Forum: Queries 07-17-2012, 02:34 PM
Replies: 13
Views: 1,106
Posted By kimberlin
Re: Problem with multitable query

According to the properties tab for the placement history subform, its record source is tblWorkerClient and its the combo box for trade within that which is the one I'm trying to do as in your point...
Forum: Queries 07-17-2012, 01:59 PM
Replies: 13
Views: 1,106
Posted By kimberlin
Re: Problem with multitable query

So the worker ID from the workertrade table and the two fields in the trade table are the ones I need to get for the row source trade name in the placement history with the control source as...
Forum: Queries 07-17-2012, 01:39 PM
Replies: 13
Views: 1,106
Posted By kimberlin
Re: Problem with multitable query

ok now I'm even more confused as some of our workers have several trades that they are registered as doing (maybe I should have put some dummy data in to show that), so I thought that would need a...
Forum: Queries 07-17-2012, 12:58 PM
Replies: 13
Views: 1,106
Posted By kimberlin
Re: Problem with multitable query

Thank you very much for taking the time to look over this for me! I think I understand most of what you are saying, the only bit I'm a bit stumped on is the using two tables as a row source for trade...
Forum: Queries 07-17-2012, 10:41 AM
Replies: 13
Views: 1,106
Posted By kimberlin
Question Re: Problem with multitable query

Ok, I've gone back into the tables and removed all the look up fields and tried to get them into the forms as combos instead. I've put in some dummy data and have also added an extra table into the...
Forum: Queries 07-17-2012, 09:58 AM
Replies: 13
Views: 1,106
Posted By kimberlin
Re: Problem with multitable query

Thanks for those links. I will go and remove the lookups from the table now and feed some dummy data in. I had copied the one that I was using at work today with some data in to my memory stick and...
Forum: Queries 07-17-2012, 09:52 AM
Replies: 13
Views: 1,106
Posted By kimberlin
Re: Problem with multitable query

Hi, I didn't realise that I could get up more fields than the number of parameters passed from a form.

The SQL for the current search query is:

SELECT tblWorker.[Worker Name],...
Forum: Queries 07-17-2012, 09:38 AM
Replies: 13
Views: 1,106
Posted By kimberlin
Question Problem with multitable query

Hi there I'm hoping that someone can help me with this one. It's the first time I've had to create a database and I know zilch about coding so tried to do everything using the wizards within Access...
Forum: Queries 09-17-2011, 11:08 PM
Replies: 8
Views: 1,220
Posted By kimberlin
Re: SQL problems in query

Hit a slight problem now as it seems to think that I have to answer questions about all those criteria before I can open the form which is supposed to control it all!
Forum: Queries 09-17-2011, 10:58 PM
Replies: 8
Views: 1,220
Posted By kimberlin
Re: SQL problems in query

Thank you Taruz, that set of coding has saved fine without any error messages coming up. Hopefully I'll now be able to get the rest of this database finished before I go back to work tomorrow.
Forum: Queries 09-17-2011, 01:01 PM
Replies: 8
Views: 1,220
Posted By kimberlin
Re: SQL problems in query - update

I've tried deleting the coding that I had in the SQL view of that query and doing a copy paste of the SQL which Taruz used but now I'm getting another error message coming up which is in the attached...
Forum: Queries 09-17-2011, 09:51 AM
Replies: 8
Views: 1,220
Posted By kimberlin
Re: SQL problems in query

I didn't realise that I could do it as a lot of IIF statements but I must admit I am confused by what you are asking the results to show as it looks as though you are saying if there's nothing in...
Forum: Queries 09-17-2011, 09:44 AM
Replies: 8
Views: 1,220
Posted By kimberlin
Re: SQL problems in query

Thank you for that link, I've just watched the video on that page and it does seem to do the sort of search that I am after. I didn't realise about the indexing either so I'm going to go into my...
Forum: Queries 09-17-2011, 12:36 AM
Replies: 8
Views: 1,220
Posted By kimberlin
Question SQL problems in query

Hi, I'm having to base an optional multi-parameter form on a query as the parameters come from two different tables and I'm getting problems with the construction of the SQL in the query. My...
Forum: Forms 08-29-2011, 10:32 AM
Replies: 7
Views: 910
Posted By kimberlin
Re: Help needed with data entry form properties.

I had tried using the option 2 approach and I put it into the two different events in the combo box properties for the PaycompID. It would allow me to type a new entry on the form but when ever I...
Forum: Forms 08-29-2011, 08:52 AM
Replies: 7
Views: 910
Posted By kimberlin
Re: Help needed with data entry form properties.

Sorry, I must have phrased that bit wrong, I meant that I changed the form and field names given in the example code to match those in my database. After all that typing and double checking of...
Forum: Forms 08-29-2011, 06:30 AM
Replies: 7
Views: 910
Posted By kimberlin
Re: Help needed with data entry form properties.

ok, I've typed all the given code (changing the form and field names) into the double click builder in the combo's property box (I take it it means the one within the form?) but then it says about...
Forum: Forms 08-29-2011, 05:05 AM
Replies: 7
Views: 910
Posted By kimberlin
Re: Help needed with data entry form properties.

Thank you very much for the link. I'm printing it out as I type!
Forum: Forms 08-29-2011, 02:52 AM
Replies: 7
Views: 910
Posted By kimberlin
Help needed with data entry form properties.

Most of the form seems to be working ok with the exception of the combobox for the PayingCompID on the third tab. I want it to be able to add extra payment companies when necessary to the list but...
Forum: Forms 08-28-2011, 12:54 PM
Replies: 18
Views: 1,876
Posted By kimberlin
Re: List box row source

Ok, I hadn't spotted that typo so thanks for pointing it out Gina. I'll go and correct it now.
Showing results 1 to 25 of 64

 
Forum Jump



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