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

Why I want to be able to do is so that I can easily trim the directory string at the nth \ and then add in a new directory location C:mydocuments\floder1\folder2\folder3 C:mydocuments\floder1\folder2\folder4 C:mydocuments\floder1\folder5

x = mid(mystring,n,1) n represents the starting point of the function, while the 1 represents the lenght of the trimming I will provide an example C:mydocuments\floder1\folder2\folder3 I want to locate the second \ in the string

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

Neil, thanks for the reply but I am still confused. I understand the concept of the table containing all dogs but the linking the lookup back to the table is what is causing me some trouble. From Sire I have the look up: SELECT tblDog.Name, tblDog.DOB, tblDog.Sex FROM tblDog; But then...

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

Are you entering this into the expression builder as part of a query. I have tried both ways and no loving. Can you cut and past the expression that you got to work from your query. I think 5 mod 2 is a VB format.

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

If the format is consistant use the Split function. You specify the delimiter and the string and it is split into the components.

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

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

Make the textbox that contains the text transpartent and place another box behind it. Then use us VB code to change the colour of the txtboxes in back. You can then highlight the entire row.

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 understand and am familiar with that method. However, I may have parts that may not be in the list and will need to be able to add parts to the list. My idea is to select a part from the cbo box and the after_update will have code that will copy the details from the cbobox source to the...