Search results

For my knowledge in Access if you want to transfer data from table to another the recordset is the best tool if that is not what you are looking for then kindly wait lots of expertise are reading the posts daily you might get a better answer and am sure you will

A while ago I just answered a post similar to this You have in your form text boxes for the three control you are talking about in here I will call them txtNum1 , txtNum2, txtSum Then go to txtNum1 text box properties click on event tab and on the after update Launch it's code for vb and write...

You can do the following Into the event procedure of after update for the cost you write Me.totalCost = Me.Cost + Me.PostageCost And on the postage cost control also on the after update event write the same code so in both controls anything you modify in the numbers it will always update your...

I think your best practice is the record set. As I understood from your detailed explanation that you need to store the data of records for later inspection but you don't want a duplicated records The best thing you do is to use the recordset on the If function as like; On error go to ErrHandler...

Simply divide your final result onto 100 How you are writing the code or the query function can you kindly explain it more in case you still have a problem WRite you code or attach a jpeg foR your query

How are hiding you ribbon stuc Because I am using these modules in my database and it works fine but I have my startup form to hide the ribbon and my loaded main form settings is popup = yes Try this Else did you try the database before importing it into your database and checked if it works...

That's good at least it works wizards is not always the solution

You can try to put an if statement ( Form On Current Event ) If Me.YourTextBoxName = "closed" Then Me.AllowEdits= False Else Me.AllowEdits = True End If

Try and check if your sub form is set to allow addition in the property sheet

Check this link it might help the thread explains how to create find as you type code http://allenbrowne.com/appfindasutype.html

Jdraw Thanks for your post actually it is an easier way from what I am doing even thought my code is working perfect but still I found your suggestion much easier to be done Thanks again

Well in access 2010 you can set it on the text box input mask on the properties of the text box I don't know if its the same on access 2013 but it should be

Click on your table and click on the form wizard and follow the steps after you finish creating your form view it in design view and in the from toolbox choose a listbox and click on your form details a list wizard will popup then select the option of find the record and showing it follow the...

I have a database running on the server used by 15 users, at the begging I thought I can make one frontend and it should work fine but the first running day was so crazy as full of errors exactly as what Bob said, now I just have a folder on each user pc all I need after modifying my front end...

Hi ml8889 find the attached database, you have a sample form inside showing you how to do that, but I am not sure how it will behave if you have so much controls in a form. regards. khodr.

Hello Rx, it is very easy and simple you don't need to write that much code. it is all about Me.InsideWidth = YourNumber * 1440 I have already made a sample form and attached it here it shows you how to hide controls and show it again while changing the width exactly as you want, I hope this is...

River, I went through your database, and it is really tough to be fixed, the relationship has been created in a way which is not really able to be fixed or repaired you need to delete all tables data and delete the realtion ships add some extra fields to the tables and link your One-to-Many...

2007 hmm ok let me see what I can do I will check and come back to you In all cases don't worry in the morning when I go to the office I will convert the database and upload it again

hello river would you please fill some sample data in your employee details table and tell which table or form you want to insert as a sub form in your frnEmployeeDetails, be noted that the subform should be related to the EmployeeDetails table.

what is the version of access you are using? the database is designed to work with Access 2010 I download it back and checked it and it works fine, tell me then what version of access you are using by then i have to design the database to work with that version.