Search results

It's about time for me to wrap it up for the evening here, so I don't have time to produce any tested code right now, but here is how I would probably approach a situation like this. I would take advantage of the Tag property of the Controls (labels, text boxes, etc.) involved. So, for example...

You need another table, with a foreign key field to relate it to the Client table, a Date field and a text or memo field (depending on how long your notes are). That way each client can have as many, or as few, related notes as necessary.

Ah, someone from the neighborhood! Thanks for saying Hi. There's another poster here named RX who's from the area also I believe.

IMDB has plain text files available for download here. They are GNU zip files so it would need to be extracted and parsed after download. Probably not too difficult to parse, but I've never had need so haven't actually tried it. I can't do it from work but if I get time later at home I can play...

Thanks for the insight Jeff. Inside/Out was a good resource when I was first investigating the new web apps in A2010. I have a 2010 web app running on Sharepoint via Office 365. Looking forward to your new book because I am interested in finding out what additional design and/or relational tools...

You can search for the character codes for Carriage Return - Chr(13) and Line Feed - Chr(10) and replace them. You would need to be careful because there may be instances of CR/LF that you don't want to replace and end up with just one long sting of text. At first - and on a backup copy of your...

Format(DateValue([DateField]),"mm/dd/yy")

That's not entirely true. An A2010 or A2013 web app can be a hybrid, meaning that it can contain both web objects (queries, forms, reports) and client objects. Client objects will only run inside the Access client, but still have the same functionality and design options that you're used to with...

That's great if you solved your own problem, but it would be better if you posted the solution so others that might come across this thread in the future might benefit.

@ OP I think you had a reply here that got lost when the site crashed. Post back if you are still looking for help on this.

Yes, if you use a combo box with the Limit To List property set to Yes, then you use the Not In List event to handle adding new values that the user enters. It wouldn't really be necessary to have them select Other first, then enter the new value. They would just enter the new value directly in...

I don't have A2013 where I am now, but I recall seeing several available templates for both web and desktop. Well, what might be considered a "traditional" Access database would not be web compatible. The new web objects have design restrictions that traditional client objects do not. For...

You would need criteria like the following; Where [Assessment Date] Is Null Or [Placement Fee Paid] = False Or [TJ Completed] = False This criteria could be applied to a query which could then be used as the record source for a report, or it could be applied directly to a report in the Where...

The Loan and Repayment forms should be sub forms on your main form. Sub forms are contained within a control called a Subform Control. The Subform Control has a Master/Child link property which controls the foreign key. See the illustrations in post #4 of this thread for a visual.

You cannot have a query try to retrieve criteria from a report that uses that same query as its record source because, as you guessed, the query needs the criteria before the report is opened. You will need to supply the criteria some other way, like in a form - which is what one would normally...

Yes. It's called a sub form. When you use a Subform Control, the Master/Child link property automatically handles the insertion of the foreign key value when you add records in the sub form. You can set up a form like this with the wizard if you're not familiar with it.

You shouldn't have quotes around the form reference in the criteria. Plus, based on your description of what you want, you need to return only the first letter of the customer name. Try this; Like Left([Forms]![NewAllCustomerListF]![CustomerName],1) & "*"

I must be missing something. Sub delay1_AfterUpdate() Me.dealay2 = 4 End Sub If you want delay2 to display the number 4 no matter what is entered in delay1, then why the code to begin with? Why not just make the default value 4, or better yet use a label? Check to make sure you didn't end up...

There was a power outage at the site's data center, so they had to restore from the most recent backup. Posts from the 24 hour period prior to the restore were lost. See here for more.

I'm not sure I follow what you're trying to do here. Reports are a static (read only) display of data, so any criteria needed for filtering should be applied before the report is opened.