Search results

The Access graphs don't make any sense to me. It's like learning a who new package for a tool that very rarely gets used as is. Anyway, I figured it out for anyone who is interested. You need to the Verb in the Property Sheet to -3. I haven't tested the other numbers, but that seems to work...

I have a linked Excel graph in my form. The process I go though to update them is: User clicks on button Excel opens up Procedure in Excel runs that updates the data and the graphs Excel Closes The user does not see any of that. This process works fine. But the linked graph does not actually...

I have created a Macro-Enabled Worksheet Object containing an Excel Graph in Access. It opens nicely when I right click and select Macro-Enabled Worksheet Object -> Open. My question is how can I accomplish the same thing using VBA code. Thanks in advance.

The other thing I notices just now is that without running any code if I copy the excel chart to access and have both opened at the same time, when I make changes to excel chart then access changes immediately. But if I close Excel but keep Access opened, then I open Excel then they are not...

I'm trying to have a linked Excel chart in Access form. What I've done so far is create a chart in Excel and Paste Special>>Linked into Access. I also have code inside Excel that will update chart data, it works fine. Then I have code in Access that calls the code in Excel to update the data...

problem solved! Thank you... :banghead:

I'm experiencing weird behavior with my form name. I saved my form with a particular name and I have used that name all throughout my code and it still works fine. But when I open that form, the name I see on the top of the form is not that name at all. It's actually some value I gave a combo...

I have this chart, and Im trying to reduce the space between the bars. Does anyone know how to do it in VBA? Thanks

Sorry if this seems like a weird questions but I was unable to find much on this, but what is the type of SQL that Access accepts? I'm familiar with SQL Server which uses T-SQL. I just want to know if there are any functions which are available to Access SQL but not in normal SQL

I building a front end UI for SQL Server. Im trying to figure out why certain functions are taking long to process. I know that Im running a lot of functions, but I want to know if there was any way to speed things up. For example, one button will launch 20 functions whose results will be...

ok, so when ever I import integers from SQL Server into Access I should use VBA Long insted of integer to be safe. thanks

Ive figured it out. The id column in access was set to integer, when I set it to Long it worked. Although Im not sure why this made a different. I thought that Integer has a much greater limit than 32,000 Also I was not getting an error that the number cant fit?

Im experiencing very weird behavior from Access. Im populating Access table using a stored procedure from SQL Server. Here is the code that does the populating. The problem area is the rst!id (highlighted in red). This is the Identity Column from SQL Server. When Access gets to 32768 it results...

spot on ! thank you very much

Ive created a table in Access but when I click on the filter option, it comes out blank. Im using VBA code to populate the table from SQL server. All other column work fine. I have attached a screenshot of what it looks like. There is data in that column. Does anyone know what could cause...

one user no images its a front end to a SQL DB. Im currently building it, so im always deleting and adding tables and data. It actaully jumped very quickly, must be one of the processes that Im doing. Im keeping a manual backup of my versions on daily basis, and it jumped from about 64mb to 160...

so is it like a log file in sql server?

I ran Compact And Repair and it reduced the size to 14MB. Why does it go up so fast?

Im not sure what is causing such jump in size. I have about 20 tables, each has maybe 100 rows. The biggest table as 3700 rows. But the total file size is close to 700MB. Im using Access 2010. Thanks.

good point. thanks again:)