Search results

Thank you! That worked :). Hmm, I've tried searching for it on google but can't seem to find what I need, the strWhere line of code changes slightly when it's a number and not text, but I can't seem to find it anywhere. Which bit needs to be changed?

Hey guys, I have a form that allows a user to search for a client. There's currently 4 different ways the user can search, by account number, client name, postcode and creditor. Now, the clients name is stored as a full name, there's no seperate fields for first and last name. Typically a...

Perfect! That's exactly what was happening to me. Thanks for helping :)

Hey guys, I'm having an issue with one of my queries. Basically I'm trying to create a performance report that uses the following fields: Filterer (Text) Advisor (Text) LeadSource (Text) Now, the process is as follows: When a client phones in, the filterer enters them onto our system...

Hi Ginna, Thanks for taking the time to reply to this. I've had a look through that page you gave me but I'm not too sure how that would help, I tried to download the example but it seems the page no longer exists. Putting criteria on the button seems to be what I need, but I'm unsure on what...

Hey guys, I've just created a button that uses the RunApp macro to open up a mail merge for our database. Is it possbile through some VBA code to jump to an exact record in the mail merge? So, for example, if I'm on AccountNumber 29 and click the Mail Merge button, the mail merge will open up...

Thanks for all your help Rain, the demo you did for me has definitely helped! I'll be sure to look up on the append query and the normalisation stuff, when I first started the project I wasn't the best at Access so a lot of poor design decisions were made. This has helped me restructure the...

That's brilliant Rain, thank you so much, I understand it perfectly now! I do, however, have one more question! As I'm changing the layout of my tables, how do I get all the data that I currently have in these tables into the tables I've just created? Is it just a case of copying and pasting the...

No need to apologise! Thank you for taking the time to help :)

Rather than list all my tables I'll just upload the back end, some of the fields will be blank due to some information I needed to remove!

Hi jdraw, When I remove the table level lookup it just provides me with the ID of the Creditor and not the value of CreditorName. Is there a way around this?

I've tried to do that, whenever I introduce the CreditorInfo table to my query it makes all the results dissappear...here's the SQL to my query with the CreditorInfo table in it (note that there's some more tables/queries in there to get all the fields I need in there): SELECT Creditors.PKey...

Hey guys, I seem to have fallen victim to the evils of lookup fields...I'm trying to create a query that I can use in a mail merge, but my current table setup is giving me a lot of problems. Basically I have two tables, one called Creditors and one called CreditorInfo. Creditor info stores all...

Hi Bob, That sorted it! Thank you! :)

I tried that too...however, even when the field is empty it still allows it to be submitted and no error message pops up. I'm probably doing something really stupid because I know this has worked for other people after doing a fair bit of research online...

Well, that's what I originally had and it didn't seem to work. I'm really confused as to why it's not working. I'm 100% sure that txtNarrative is the name of the text box that needs checking. I thought maybe because I wasn't specifying the sub form it wasn't finding the field but it's definitely...

Hey guys, I'm having problems trying to make a required field pop up a message when it's left blank. It's for a subform and I don't think the code I'm using as the destination is right. Here's what I have at the moment: Private Sub Form_BeforeUpdate(Cancel As Integer) If...

Sorry for the late reply, I think I'm having a few problems with my second table, would you be able to create a quick demo for me just so I can see how it works? My current tables are: Lookup: Inc/ExpID (Autonumber) Source (Text - contains a list of "Income" and "Expenditure") Type (A list...

So…let me get this right, I have one table (say I’ll call this Lookup) with the following fields: ID (AutoNumber) Source (Text - A list that has Income/Expenditure as values) Type (Text – a list of all the different types of income/expenditure) Then I need to make another table (that...

Hmm, I'm a bit confused by the last bit. The Expenditure and Income both have their own types, by having one field 'Type' wouldn't that mean they'll share whatever is stored in that? So for example someone would be able to use an Income type for an Expenditure? E.g. Rent as a type of Income...