Tim Mullin
Last Activity: Aug 16 '12, 08:46 PM
Joined: Aug 17 '10
Location: Chicago
-
My response was to zmbd's post...Just saw your Rabbit - using VBA would it be possible to get it to work? I'm open to spending a fair amount of time on this as it would save us a whole lot more in the long run... -
hmmm..I gave it a few tries but couldn't get anything to work.
I first tried to use the "not a digit" ([!0-9]) pattern but it kept giving me an error saying it was invalid bracket name. The code looked like this:
Like "*" & [TableB].[Name] & "*" And Like [!0-9]
Even if this did work it still wouldn't solve the issue fully, as some of the "Names" have numbers in...Leave a comment:
-
How you described it is exactly correct - you even went a step further to something I didn't think about. I would like the query to recognize the varying formats from TableA and TableB as the same company, and if we could set it up to ignore all non-alphanumeric information that would be outstanding. (In theory this would solve the problem)
TableB is populated by by the "raw" data from the commission statements we receive that...Leave a comment:
-
Allow Like Operator To Include Results With Differing Punctuation
Hello Everyone,
I'm having some trouble with a query I'm trying to run and I cannot find any previous cases with solid solutions online...hoping someone could help!
Every month we receive a commission statement from a company we work with that has a list of names on it, along with other details regarding the commission being paid. We have a database in place that helps us keep track of these commissions and we want to implement... -
My apologies for the shoddy explanation... I'll try again a different way.
Table 1: Clients
Field 1: ID [AutoNumber]
Field 2: ClientName (Primary Key)
Table 2: Commissions
Field 1: ID [AutoNumber](Primary Key)
Field 2: Client Name (in relationship with Clients.ClientN ame so that the field has a dropdown box with each ClientName available)
When I import the data from excel into the Commissions...Leave a comment:
-
Can I Import Information from Excel into Linked Field in Access?
Hello All,
I have a table (Commissions) in Access that has a field (ClientName) that is linked to a "ClientName " field in a "Clients" table. The relationship was made via the LookUp Wizard.
I would like to be able to import spreadhseets of data into the "Commission s" table, however I am seeing an issue every time I attempt it. The spreadsheet in excel matches the field title names for the table... -
NeoPa,
My sincere apoligies for falling off the map on this one, have not had time to work on the database in the past couple of weeks. I have taken your suggestion and am using a query to match up the data and form a report instead of applying a code process within the forms. It seems to be working flawlessly, however I have run across some new issues (unrelated to this one), but I will post a new topic for it. Thanks again for all...Leave a comment:
-
Thank you for the response NeoPa. At this point in time we are just testing out a few different options on how to automate certain processes and this seems like the best way at the moment.
If possible I would like any help I can to get this operating...I'v e included table names and such below...
Source Table: Clients
Source Fields: ClientName, Agent1, Agent1Percent, Agent2, and Agent2Percent
The data that...Leave a comment:
-
How to apply code process to all forms from single onclick
Hello All,
I have created a table (CommissionStat ements) in Access that will store all of our data that we import from Excel.
Certain fields of the CommissionState ments table are computed using data from a linked table (Clients) via a button that is programed with an onlcick. This button is on the CommissionState ments form that contains all the fields of that table. The code is as follows:
...Code:Me!Agent1 = Me!ClientName.Column(1)
-
I could, but was hoping to use a combobox because it works better for my layout. If there isn't a simple fix I might have to switch it though...Leave a comment:
-
@slenish - thanks for providing the sample, though I'm not so much worried about the user changing the selection as I am about the user being able to place the cursor in the combobox field and type away
@malcolmk - having the Limit To List does prompt the error message if the user (for whatever reason) makes changes, however I was hoping to avoid that process altogether...Leave a comment:
-
How can I prevent any input to a Combo Box without "Locking" it?
Hello all,
I have an issue that I just realized that I can seem to figure out on my own...
I have a few combo boxes on a form that are all linked to different tables. Each combo box has the following settings:
Limit To List - Yes
Allow Value List Edits - No
However simply placing the cursor in the combobox allows you to click and edit whatever is chosen...is there a way to "Lock"... -
Tim Mullin replied to Is it possible to generate an "end date" after entering start date and term length?in AccessActually I take that back... I simply replaced the EndDate column headers in each of the queries with
and now they all work perfectly. Obviously as mentioned above having the data like this isn't the best way of doing it, however I feel that this is the best way to prevent the great deal of potential human error that could arise from manually computing the end date.Code:EndDate: DateAdd('m',[Term],[StartDate])
Thanks...Leave a comment:
-
Tim Mullin replied to Is it possible to generate an "end date" after entering start date and term length?in AccessI do have the number of month choices set specifically in a combo box, however the resulting end date is too important with what we do to not have it stored, so I've gone ahead and removed the "auto-generate" function.
Numerous queries that use the end date as some sort of parameter that we need won't work (without more intense behind the scenes coding), so I think I'm going to leave it as a manual entry.
Thanks...Leave a comment:
-
Stewart - this is EXACTLY what I was looking for, Thank you so much! Got it up and running on a few combo and list boxes and it works like a charm.
Thanks to everyone else too for their help, I truly appreciate it. There is no way I would be able to finish the database project without this site.Leave a comment:
-
The code used to execute the query is as follows:
...Code:SELECT Contracts.SalesRep, Contracts.ClientName, Contracts.Commodity, Contracts.Type, Contracts.SignDate, Contracts.[Renewal/New], Contracts.Fee, Contracts.Supplier, Contracts.StartDate, Contracts.Term, Contracts.EndDate, Contracts.ContractRate, Contracts.AnnualUsage, Contracts.UsageType, Contracts.Notes FROM Contracts WHERE (((Contracts.SalesRep)=[Forms]![QueryScreen]![List69]));
Leave a comment:
-
Thanks for the reply - Do I need to write the wildcard ("*") into the initial code for the row source for the listbox? I tried the code you provided but got nothing to return, and I think it might be on my end. Any suggestions?Leave a comment:
-
Awesome! Thank you so much, it works perfectly now. I appreciate all the help!Leave a comment:
-
Any suggestions on making the displayed text an active hyperlink? I can't seem to figure it out...Leave a comment:
-
It looks like I spoke to soon...
For some reason when the folder path is displayed in the field (the field is formatted as a hyperlink) when you click on it nothing happens. It looks as though its a hyperlink, but an explorer window open to that folder does not appear as it does if you copy and paste the folder path into the field... Any suggestions??Leave a comment:
No activity results to display
Leave a comment: