Search results

I'm trying to create a query that will update as a textbox is filled, but if there is nothing in the textbox I want it to act as if there is no criteria IIf(len([Forms].[frmMembers].[txtLastName]) > 0 , _ InStr(1, Left([Forms].[frmMembers].[txtLastName,_...

Although I have not been around long, I have finally started reading other threads and have been trying to provide my input. It seems to me that many people seem to have one common problem, and I feel that this deserves a acronym all to itself: L2N : Learn to Normalize This might simplify...

I realized after getting a Run Time Error: ...on my university's course website, that there may be a way to import some of their data. Let me mention also that I have NO intention whatsoever to edit or damage anything that they have in any of their tables. The website that I would like to...

http://davidthompson.typepad.com/davidthompson/2009/07/word-salad.html It hurts to watch this.

I have a form with a textbox "txtDateSent". To help speed up some code/queries, I have created a function "DateGrab()" which reads that text box for the date value (from a datepicker). For some reason it is giving me RTE-13 - 'Type Mismatch'. I think it might have to do with the fact that I am...

Is it possible to update a sub-form that was created from a query that has been updated since its initial creation? Or is my only option to remake the subform?

I am trying to set the value of a Checkbox inside a If/Then function in the Form_Load() function, but I keep getting a run time error. What is the single line of code that will set my check box to true/false? I expect something along the lines of chkSent.value = True but it offers me Run Time...

I have a subform that will only display a single record (data is set so there can only be a single active record). How can I remove the record count bar at the bottom of the subform?

I'm attempting to export a table that is compiled via queries to be used as a report. The table has 17 fields, and only holds 50 records(+/-5). When I run export code it gives me the 3190 error : "Too many fields defined". The error occurs right after the section of code in red. strTable =...

I keep getting a "compile error: User Defined Type not defined" when I try to run a concacnation function. code being as follows, and when I go to debug it highlights the red line. Public Function Conc(ID) As String ''the following was adapted from code was found at...

I have a database that I created (it was my first) and it is in desperate need of overhaul. Its only being used by one person, is it worth the effort to split it into a front/back end type database, or is that too much trouble? If it is suggested, is there a useful tutorial somewhere to...

i'm trying to automate the excel function =COUNTIF(D2:D48, "> 0") in my vb code, but how do I work around the quotation marks in the criteria field? strCell2 = "= COUNTIF(" & strChar(o)& "2:"& strChar(o) & (intRecordNumber - 1) & ", "> 0" )"

I'm creating a report in excel that needs to adapt to the output. Is there a way to count letters of the alphabet (a-b..y-z) similar to using regular numerical variables? My current approach is as follows. It is not implemented yet since I am hoping there is a better way Dim strChar(1 to 26)...

I'm using the following code to export a set of queries into an excel report. What do i need to add in to have a variable count the number of records I export so that I can add standard fields at the end of the excel sheet? Public Function ExportReportDumpSummary() Dim strWorksheet As...

I recently completed my first database, which IMHO turned out well. My boss liked it so much he commissioned me to do another. Realizing that the 2 databases will carry similar parent tables and structure, I think combining the two tables is a "cleaner" solution. Incorporating the new dataset is...

Access 2007 I am busy adapting the code found in http://www.access-programmers.co.uk/forums/showthread.php?t=67164 but when I copy it to my database it crashes when it get to "Dim cnn As ADODB.connection". What is going wrong, It works when I run the sample database, but when I copy or even...

I have a query dumping into a table which is used to generate a report. Under certain circumstances, nearly duplicate entries appear in the table, the only difference being in 1 of the 16 columns. That one column is a text field titled "issues". Is there a way to write a query that will combine...

I am creating a percent line in my code in an effort to summarize data in a report. I'm quite rusty on my VB, and I just can't remember how to limit the length of numbers my code is as follows: lblPerct.Caption = Str((lblSending.Caption / lblTotal.Caption) * 100) & "%" the code works...

My report is effectively a spreadsheet. the only problem is that I cannot compress the output to fit onto a single page like the old spreadsheet used to be able to. I've changed and played with most settings in the property sheet, but to no avail. The attached picture is at good as it has...

Access 2007 I am trying to set up a conditional formatting on the cells in a report, but I can't seem to get it right, I searched but didn't find anything applicable. I'm having issues with turning a certain text value yellow. The fields have 4 specific outputs. Empty (null), any possitive...