Search results

I think this got overlooked, any comments?

this doesn't stop me from creating a table in the front end for report purposes, right?

HTC, You say that you start with the split database? if so, once split, if I want to add a whole new table, would I need to go to backend to create it? What happens when I move the files? Since I'm not placing the files in a shared drive, would they automatically update when I move them, or...

You have a point, but what about something like sugar. sure some recipes call for it, and you can calculate the after quantity using the recipe, but how are you going to account to the .5-8 teaspoons that you use in your coffee/tea in the morning, how about if you have guests and you serve them...

Can we also include a scale for products that aren't spent after one use? Like flour, weigh it when you buy it and then weigh it each time you put it back in the pantry. How about if you are adding a recipe list, having it list recipes you can make with what you currently have in stock? This...

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...

can you show me exactly what you're talking about, because trying this is causing Run-time error 1004. here is what i changed it to. strFormula2 = "= COUNTIF(" & strChar(o) & "2:" & strChar(o) &_ (intRecordNumber - 1) & ",' >0 ')"

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 like that method too actually, I'm actually going to swap that out for the case-select function. Thanks.

Ok, well I guess there was no answers to this... so this was my final solution. In my module: Public Function AlphaDefine(intCount As Integer) Select Case intCount Case 0 AlphaDefine = "A" Case 1 AlphaDefine = "B" Case 2...

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 started trudging through the updates. I was wondering how I could accomplish this, thanks for the tip.

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...

I saw a bloke chatting up a cheetah, i think he was "trying to pull a fast one"

Another thing to check is if you can open your database on another system. This may specify if it is an access problem or a system issue. You may also try to open VB itself or with another office application and see if that is a source of the issue.

I am resurrecting this baby! I have modified the code in the attachment to fit my need, it is as follows: Public Function Conc(ID) As String Dim cnn As ADODB.Connection Dim rs As New ADODB.Recordset Dim SQL As String Dim sConc As String 'Dim rs As Recordset 'Dim cnn As...

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...

solved it via Format() command. Thanks for the suggestion. Here is my final code. Using the "%" sign eliminated the need for the " * 100" portion of my original code. lblPerct.Caption = Format(Str((lblSending.Caption / lblTotal.Caption)), "#00%")