Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 138
Search took 0.05 seconds.
Search: Posts Made By: Singh400
Forum: Forms 03-12-2009, 03:04 AM
Replies: 1
Views: 602
Posted By Singh400
Re: Excluding last selected value

Ok either I didn't explain myself properly and know has no idea what I'm going on about or it's not possible. Any nudges in the right direction?

SELECT tblTypeOfStatus.TypeOfStatus FROM...
Forum: Forms 03-11-2009, 04:02 AM
Replies: 1
Views: 602
Posted By Singh400
Excluding last selected value

I have a form (frmStatus). Itís in continuous forms view. It pulls information from tblTypeOfStatus. I have a total of 15 statuses, but for the sake of making stuff easy lets say 5.

What current...
Forum: Forms 02-16-2009, 07:52 AM
Replies: 6
Views: 11,504
Posted By Singh400
Re: Popup Subform linked to MainForm

You have defined a field as a PK, which requires to be filled in when another other field on the form is edited and at the same time you are leaving the PK field blank. Which is not allowed.

I'd...
Forum: Theory and practice of database design 02-16-2009, 03:00 AM
Replies: 19
Views: 2,576
Posted By Singh400
Re: Best way to do this?

Ahhh I've seen what you've done there. Nice idea. Having a little trouble implementing this at this moment. Think I've been staring at it too long and I'm just stuck in the same line of thought!
...
Forum: Theory and practice of database design 02-13-2009, 08:29 AM
Replies: 19
Views: 2,576
Posted By Singh400
Re: Best way to do this?

So what fields would my junction table contain? I already have tblBookings and tblStatus linked via fldBookingNo. Gah, who thought given a booking a status would be so complicated!

Blimey, then I...
Forum: General 02-13-2009, 08:18 AM
Replies: 30
Views: 73,717
Posted By Singh400
Re: "there isn't enough memory to perform this operation"

Just had this happen to me. I had just added a label to my main form (frmBookings) and gave it a hyperlink to another form in the same database. I then tried to go into form view, but it wouldn’t. It...
Forum: Theory and practice of database design 02-13-2009, 05:36 AM
Replies: 19
Views: 2,576
Posted By Singh400
Re: Best way to do this?

Yeah I've already done it, not gone down the combi root though. Just sticking with option groups.
Forum: Tables 02-13-2009, 02:36 AM
Replies: 8
Views: 1,848
Posted By Singh400
Re: Only replicate the table structure, not the records

I'm probably wrong (and this kind of topic, is wayyyy over my head), but why don't you just create a new DB and import the old DB into it. And tell it just to copy tables, queries and relationship...
Forum: Theory and practice of database design 02-13-2009, 02:27 AM
Replies: 19
Views: 2,576
Posted By Singh400
Re: Best way to do this?

Iím guessing by the unanimous silence, this canít be done and Iím talking poppycock. So I guess I have to make a status field for each status and do something fancy with a sub form.

If anyone else...
Forum: Modules & VBA 02-12-2009, 08:06 AM
Replies: 11
Views: 1,084
Posted By Singh400
Re: Cascading comboboxes

Agree with JANR the .requery method is much easier to use and maintain/update. If you still can't get it to work, upload the db here and I'm sure we can help :)
Forum: General 02-12-2009, 04:47 AM
Replies: 4
Views: 806
Posted By Singh400
Re: Security options help please

Right click on *.mdb file, select Properties and make sure "Read Only" is not checked.
Forum: Theory and practice of database design 02-12-2009, 03:26 AM
Replies: 19
Views: 2,576
Posted By Singh400
Re: Best way to do this?

Just been playing about with this. Trying an option group and dropping several check boxes in there. Just trying to enable multiple selection within the option group. Just can't figure out how...
Forum: Theory and practice of database design 02-11-2009, 07:38 AM
Replies: 19
Views: 2,576
Posted By Singh400
Re: Best way to do this?

We create a new database every finanical year, so that shouldn't be a problem.
Forum: Modules & VBA 02-11-2009, 07:33 AM
Replies: 11
Views: 1,084
Posted By Singh400
Re: Cascading comboboxes

There are plenty of topics on this. Please use the search function.
Forum: The Watercooler 02-11-2009, 07:16 AM
Replies: 34
Views: 2,730
Posted By Singh400
Re: Aside from Access/Excel etc are you into electronic technology

You are misssing out mate. I run the same sort of setup, minus the Zune. They don't sell them in the UK yet for some reason :( All my computers and data is stored and backed up using my Windows Home...
Forum: Theory and practice of database design 02-11-2009, 07:04 AM
Replies: 19
Views: 2,576
Posted By Singh400
Re: Best way to do this?

Looks like I'll be creating a new status field then. Cheers lads/ladettes.
Forum: Theory and practice of database design 01-29-2009, 03:51 AM
Replies: 19
Views: 2,576
Posted By Singh400
Best way to do this?

Currently we only use the database to store information about bookings that have actually been booked. And anything that has yet to be booked remains on paper and in a folder.

Ideally we want to...
Forum: Reports 01-29-2009, 03:01 AM
Replies: 5
Views: 3,751
Posted By Singh400
Re: Clickable links in Report?

Ahhh nice idea http://www.access-programmers.co.uk/forums/images/icons/icon14.gif

Yeah not sure if the IT Dept is willing to do that.
Forum: Reports 01-27-2009, 08:36 AM
Replies: 5
Views: 3,751
Posted By Singh400
Re: Clickable links in Report?

FYI This wasn't designed by me, already in place when I started

Ah I see. We use the reports to easily view the information in a nice manner, instead of staring at a datasheet query. It's never...
Forum: Reports 01-27-2009, 08:12 AM
Replies: 3
Views: 1,046
Posted By Singh400
Re: Report prompts for parameter in design view

Check the underlying parameter query?
Forum: Reports 01-27-2009, 07:04 AM
Replies: 5
Views: 3,751
Posted By Singh400
Clickable links in Report?

We have frmBookings and from this, we run a report (rptBookingsByDate). As you would expect it lists all the bookings for the entered date.

The report shows a variety of information such as Venue,...
Forum: The Watercooler 01-27-2009, 04:46 AM
Replies: 34
Views: 2,730
Posted By Singh400
Re: Aside from Access/Excel etc are you into electronic technology

Yeah I'm a complete geek. Build my own computers, beta test for Microsoft. Very interested in computers. So yeah complete geek.
Forum: General 01-22-2009, 09:01 AM
Replies: 2
Views: 760
Posted By Singh400
Re: Warning Message when opening PDF

Try SetWarnings to No in the macro/vba code.
Forum: Forms 01-22-2009, 05:01 AM
Replies: 16
Views: 1,571
Posted By Singh400
Re: Tweaking my Cascading Combo Boxes

Sorry for the old-topic-bump...

To answer my own question. The .Requery method is better for cascading combo boxes.

Why you ask?

Because using the other method spits out an error when...
Forum: Modules & VBA 12-09-2008, 12:18 PM
Replies: 10
Views: 908
Posted By Singh400
Re: Simply way to use the same code in different places?

Ahhh that makes alot more sense. Will Access automatically change the respective enteries in the code for each individual field?

@MSAccessRookie: Thank you for the information!...
Showing results 1 to 25 of 138

 
Forum Jump



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