Search results

Hi, I do understand I think... Some background to why this has been asked for, we get an order off a customer we enter it into our database after we have entered a few lines we find that it uses the part number to sort its self into alphabetical order, the people working on this database would...

Hello, I have a database that has a sub-form, for the sub-form I would like to add line numbers for the different lines of data, this will help keep things tidy and in the correct order when referring to paper work. My question is how would I automate something like this, I can add in the...

Hi, Thanks for all your help, after a bit of playing and with your recommendation I have been able to get it to work. Here is the change to the code; chkAccStatus = Me.cboEmployee.Column(2) If chkAccStatus = False Then MsgBox "Your account is disabled see admin.", vbOKOnly...

Hello, This is part of the code, I have placed the DLookup in the AfterUpdate, but when it is there when I come to logon and click the button their is no value getting to the IF statement in the cmdLogin_Click. If I where to place it all in the AfterUpdate it would not work how its ment to as...

Hi, I've had a play, the "Print" didnt seem to work too well, so I used a MSGBOX and found that I wasnt getting the data from the table to compare. After playing aroung this is what I have; chkAccStatus = DLookup("chkAccStatus", "tbl_System_Users", "lngEmpID=" & lngEmpID) If...

Hi, There are no errors, When I login as either a Enable/Disabled user I get the disbaled message, the user is login into the database. I can only think that am missing something somewhere. Thanks Karl

Hi, I have been playing around with some Access tutorials on the Internet, am interested in how I would go about changing a User Login to also have enabled and disabled accounts. Here is the site; http://www.databasedev.co.uk/login.html On the cmdLogin button I have added the following...

Hi, After coming across the below code and having a play around I have come to a brick wall. I have been able to get my splash screen up, then after that my Main Menu Form with the Access application hidden, but then when I click on any of my buttons to open other forms nothing...

Hi, I looked at the other post while it seems that this will help me with what am trying to do, I don’t quite understand it all, I looked at the website that explains the rest but am at a loss with what to do with all the code. Also filename= application.GetOpenFileName () seems a simple way...

Hi, I have been looking into transferring data from Excel to Access, I have now been able to successfully do this using a Macro, however the filename / location is static in the Macro. How can I prompt the user to select the file, like in the Get External Data wizard? Here is the Macro...

Thanks to both of you for your replies... The named ranges where a good idea and worked well... Many Thanks

Hi, I have a database with two tables joined with a One-to-Many relationship, how would you import records over the two tables from one sheet. The sheet will have the enquiry detail which is one table and then the lines of the enquiry the other table. I have red up that an INSERT...

Hi, Solved this, thanks for the link to the website, when I woke up I got it.... Thanks again... Karl

Hi, I had a look at the site and believe I understand, however Access thinks the Control Name for the subform is a field, See the below error. Run-time error ‘2465’ Microsoft Office Access can’t find the field ‘ListOfOpenEnq’ referred to in your expression. Here is the code that I...

Hi, Thanks for the reply. This is new to me where do you find the CONTROL name for the different forms I have, after looking on Google and Access help I didn’t find much that made sense to me or where to find the CONTROL names. Where is the place to start looking? Many Thanks Karl

Hi, I have a main form which has a subform that data within the subform comes from a query, I would like that data to update when I have entered in new data without having to close the form, however all my attempts seem to have fail so far here is what I have. Three forms; frm_Main_Form...

Hi, All the number is for is to check the number of times a duplicate Part Number appears, so when someone is using the database they can see the about of times a price has been requested for that Part Number. In the example database I have the Part Number "ABC123" twice, so the query counts...

Hi, I have been able to create the query to get the counts of duplicate data, however am having trouble integrating this into the a form where data is displayed and edited. I have uploaded the database that I have been building; if you open the form "frm_Edit_Price_Request" you will see the...

Hi, I am using a spreadsheet that keeps a list of price requests, within that sheets is a basic formula that keeps a count to how many duplicate price requests there have been against a part number, how ever the spreadsheet is getting large and slow so Access would be better to handle a...

Hi, Simba your idea dose sound good... Could you link the tblRateType to three felids in the same table, this is why I made three tables. Each one can use a different currency and when I do calculations the one table with the relationship can influence all the calculations even when one is in...