Search results

I am trying to create a document control db. Currently I have two tables: tbl_sod : contains the name of the document and other various document specific details tbl_sod_status: contains who the document was sent to and the rev of the document that was sent. I came up with the following...

Is there a way in VB to make all data in an array null without having to loop through each item?

I am trying to create a project folder to store various items in. I have created a program that will generate the directory string but I cannot get the directory to appear in the right folders. I thought if I maintained the full path, the folders would just be created where ever the...

I have recently seen a function that will find the position of the nth character in a string but cannot remember what it was?

I have seen this same question before but could not find the response. I want to build a db for a dog breeder. tblDog is a table that contains all dogs while tblParent is to represent the link back to the tblDog to store the name of the father and mother. Currently I have a lookup between...

I am trying to convert an excel formula to be used in access. One of the functions used in the calculation is the Date function. What is the equivalent command in Access.. Excel formula =INT(($D$2-(DATE(YEAR($D$2+(MOD(8-WEEKDAY($D$2),7)-3)),1,1))-3+...

trying to use the MOD function in the expression builder but comes up with an error MOD(5,2) This is an example. The error reads, "The Expression you entered containes invaild syntax. You may have entered a comma without a preceding value or identifier" When I look in the function...

I have a form with a textbox that is to display PO text. Number of character is in excess of 255. The textbox is unbound and it populated with the use of a string variable. The string length has not been defined. The recordset does contain all the details. The problem is that when the field...

I am trying to use a Select Case but have come across what does not appear to be handled well. Can some one confirm how this should be handled or should I just use a IF...Then What I want is if the Description contains the word "KIT" then that case is selected otherwise it moves on...

I am trying to create a spare pares generator but having trouble figuring out the architecture for the tables. I am not sure how to explain this so I think the use of an example will work best. In the example I will use a mouse as a the part, keep in mind this is only an example and would not...

When the program comes accross the recordset with more then one record it does not report the correct number of records. I took the SQL statement and put it in a query and it works. I read on the forum that I should put rs.movelast before recordcount but this causes an error so did not want to...

I am using the split function to collect an array of values from a text box. Works great however, it appear that it maintains the delimiter value as well. I have tried to do a string search for Chr(13), which I believe is the correct value for a carriage return. I need to only capture the...

I have a combo box that lists available parts. I want to select a part from the combo box and added to the next record on the continuous form. How do you reference the next record on a input form so the value is displayed?

I am trying to update a record with new information. When I select the next record in a combo box, I run code that updates the record. The problem is that, the record that gets updated in the table is the new record that was selected in the combo box instead of the previous record in the the...

I am trying to export a recordset to excel. One of the values is also to be set as a hyperlink to a fill. The error message that comes up is "Type Mismatch". I include a bit more then just what I believe is the problem code so that you have a better understanding as to what is going on...

I am running a query in a combo box but for some reason the following SQL statement does not give me the result I am after. Which is to only displaying the distinct records. It continues to display the multiple occurrences of the records. I also tried distinctrow with no better results...