Search results for query: *

Could something this simple work? SELECT Tblx.Num90 FROM Tblx WHERE ((Right([Num90],2)=90)) Best, C

Ok DanKay1, I have it working. Code that works for your problem if I understand it correctly. Updates your initial values for "Coverage" based on the following: 1. From one to three records may share the same "Policy" number. 2. "Amount" will be different if more than one record share a given...

jjlogan or anyone who knows the syntax on this sort of work ... I was trying to sort out the logic for DanKay1, but I am missing something in the code I have suggested for him. I am getting errors, and would like to be more helpful to DanKay1, and would like to make that sort of code workable...

DanKay1, I have been thinking about how to get a number for how many policies share the policy same number, and then update your Coverage correctly. My inclinationt would be to have a query do a lot of the heavy work for you before you process the Coverage field Have the query sort first for...

DanKay, Sorry to dig around that question at length: but given that your whole set of records sounds like it is entirely deleted and replaced monthly, and that you are not adding lots of records in the interim, but just populate the db all at once, then I'd suspect you are fine to work up the...

DamKay When you posed the problem, Policy 01 is entered twice, once for Amount 20, once for amount 40. That's the duplication I refer to: two records for 01. Your original wording: Database Policy Amount Coverage 01 20 02 25 03 15 01 40 I suspect...

Maybe I'm missing something, but it looks like the coverage values, 01, 30 , 31 are redundant information, and that the information about policy coverage is not only already in your database, but intrinsic in the same table. If I have that all correctly, then I would use similar code to...

Hi, For brevity and clarity: CustName1 CustName2 EmpName1 EmpName2 What say? C

Can you move the calculation into the source query for your form, than treat it the same as your other columns? C

Glad I could help! C

Peryan, I'm not sure if you can programmatically sort out which control is on which tab page (someone more sophistcated might have a method) , but you can name them so that you can control the properties of only specific groups of controls - like the ones in a given part of a form, or of a...

Thanks AceMan. A star from TheAceMan is ... well, a star from a star... I ran into the issue with the 2048 character limit a while ago. I've Googled around quite a bit, using search strings like "2048 limit access listbox rowsource." To something of a novice like me, it looks like "User...

Also maybe the OldValue property if you can use it. C

Aceman, I'm a novice so I ask this to be better informed. I am hoping soon to learn more about, and to use callback functions since callback functions are presented as not being subject to the 2048 character limit. Is the limit you are referring to elsewhere in the process, or am I reading...

Could a callback function get around the 2K limit? C

Are8Jay There are lots of image management programs out there, but if you are trying to create a table of image paths, and text descriptions, and want to program it yourself, then I believe you can do it with Access / VBA using FileSystemObject and Dir function - no ActiveX controls, no common...

Hmmm... maybe it's presumptious for someone still learning Access to toss out UI design preferences to a forum with lots of seasoned pros, but I have a really good UI concept, and I use it pretty much everywhere.. It's driven by several ideas. 1. Visual simplicity wherever possible. 2. Show...

This will show up as ModelDescription in the header SELECT TblModel.ModelDesc AS ModelDescription FROM TblModel Whereas this will show just ModelDesc in the header SELECT TblModel.ModelDesc FROM TblModel In the query design view, you can put YourDesiredHeaderName and a colon ":" before the...

Googling "FileSystemObject read file txt" yields sites with clear code samples: http://www.4guysfromrolla.com/webtech/faq/FileSystemObject/faq2.shtml http://www.juicystudio.com/tutorial/asp/files.asp Check out the ReadAll command. Best, C

Vie, Try these: To "unselect" the selected items in a listbox: YourListBoxName = "" No item will be selected after. You can programmmatically make selections in a listbox YourListBoxName = Some value To set an option group to no selection: YourOptionGroupName = "" All the option buttons will...