Search results

Private Sub RelationshipHistoryArt_DblClick(Cancel As Integer) If counter = 0 Then RelationshipHistoryArt.Height = RelationshipHistoryArt.Height * 2 DateofArt.Height = DateofArt.Height * 2 Me.Detail.Height = Me.Detail.Height * 2 counter = counter + 1 ElseIf counter = 1 Then...

How do i add a gif image to Ms Access? I have tried to use the link below but step four in this doesn't happend on my PC. :( http://www.ehow.com/how_7407641_animated-gif-files-ms-access.html Am i suposed to do something more to enable something on my PC.:banghead:

Hi Developers out there, We have 4 access databases stored in our shared folder developed by yours truly. As our table and query structure are quite complex for some of the Databases, also the front end being access itself makes the same very slow. Just recently we had a discussion...

Hi, I have a List of amount and a column next to them that indicate the balance after subtracting the opening balance with each amount in the rows below. If incase the user decides to change one of the amounts, the balances need to change and be saved into the database. This is where i face my...

:confused:IS MY DATABASE CORRUPTED@!@!!! :confused: I NEED TO FIX THIS FAST. BUT HOW???:eek: ATTACHMENT IS BELOW. I tried to compact and backup. but it still show me this message. Is there something im missing.

I have created a MS access system and its bing used in 8-9 different countries for data input. Its stand alone on the server for each country. I have no access to it only the admin in each country gets to see the system. The users have no access to the backend. Recently there has been a...

I tried to use the docmd.runsql command. its gives me an error message and doesnt execute properly. The pic of the message is attached herewith.

Hi All, I need to Edit and save a form but its doesnt work. The form I am using has the save button command as. DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 The Recordsource is the table itself (tblCustomerMain_tb) and uses a filter like "CIF= 123" I have...

Hi, I am developing a MS Access Database Application that allows me to filter a customer details from a pivot table in a subform. Everything works but i keep getting a blank space in the pivot table I have attached two screenshots (One is an example of when this works and another is when...

What is the best ms access Trining or Book avaialble to get me into every level of understanding ms access applications. I'm sure I am quite Intermediate-Advanced in the field. but want to learn everything including security aspects. any website or link to help will be very much appreciated.

Hi, I want to create form that will write textboxes into which i can enter text and will save in the back end to display in the textbox. I would appreciate a link if you have one for ms access or other wise if you have one(Maybe i can get a few clues). I can pretty much figure out the...

I have set the report format in a certain way but the OutputTo command when used to export into an excel sheet it gives me a totally different view. there are 2 images below 1) Excel View of the Report 2) MS Access Design View of the Report to describe the same. As you can see everything...

I have set the report format in a certain way but the OutputTo command when used to export into an excel sheet it gives me a totally different view. there are 2 images below to describe the same. I have reomved a few descriptions so please forvive me if the images arent too clear. :o

Hi all, I had a problem with my ms access database table(main table) when it gave me a record called #deleted because this MS access DB was on the network i guess it caused this problem. But I managed to get around it without compacting and repairing the database (as it had given me a lot of...

Hi, I have a subform(OtherFac - 2nd Table) inside a form (FLAM - 1st Table) but now i want to make another subform from another [Oblig - 3rd table]. But when i try to create a relationship between the 2nd and the 3rd table its gives me an indeterminate relationhip not a one to many which is...

Hi Guys, This is the query what im trying to do is get all the customers which have exceeded their acccount limit at least twice in a month with a table that only displays the customerid and the date of the excess. Now Here is what i have done so far. I made 2 queries The First Query...

Hi Guys, we have a system to enter data and print data. now to secure the database, I have created an autoexec macro that runs at startup and check if the user is me. If its is, it will enable the bypass key so that the user (myself) can view the design view of the code else it will disable it...

Hi Everyone, This is my table and Im tring to write a query that will give me all the Names as of a particular date Ex:22-02-2010. and with it give me the increase in the ammount of that particular as of the previous day. i going nuts using the query builder. please helppp!!!! Really need...

Hi Everyone:), I looking for a way to get this query to work. UPDATE tblCust_ExcessesHistory AS TBEH LEFT JOIN tbl_Excess AS TBEX ON TBEH.Excessid = TBEX.Excessid SET TBEH.RCUTargetDate = (SELECT TBEH2.RCUTargetDate FROM tblCust_ExcessesHistory AS TBEH2, tbl_Excess AS TBEX2 WHERE...

Hi Everyone:), I looking for a way to get this query to work. UPDATE tblCust_ExcessesHistory AS TBEH LEFT JOIN tbl_Excess AS TBEX ON TBEH.Excessid = TBEX.Excessid SET TBEH.RCUTargetDate = (SELECT TBEH2.RCUTargetDate FROM tblCust_ExcessesHistory AS TBEH2, tbl_Excess AS TBEX2 WHERE...