Search results

First of all Thanks a lot for your help! Well, the problem is that the form has been created using the wizard, so I cannot find the way to change the connection string anywhere... And there is no code, so I cannot adapt the code to let sql server do all the job...

Right... It is a very small application (but too big for access for the amount of data right now), what do you suggest? To create everything new using SQL Server and .Net or Java application? And using the upsize meanwhile? Any help will be much appreciated! Thanks a lot!

ok... But how can I do it?? Where do I put this odbc connection in the wizard?? I have no idea... Do i need to create a new project on existing database and select an sql database??

Hello!!! Is it posible to connect to a Sql server database from access form, creating the form using the wizard??? I could not find the way to select tables from SQL Server when using the wizard... How could I do it??? Thanks a lot!

Hey! Thanks for your reply! I'm using Access 2003, and SQL Server 2005... I read about this upsizing wizard... and it looks easy... The reason for the migration is only the size of the database... It is needed more space to store all the data...

Hello all! I have an application in access and it is too small for me now, and I need to migrate it to SQL. I've never done something like that before, so I have no clue where to start... I figure out I need to export all the data from the access database to SQL database. How can I do it...

I'm not able even to open the code. Anyway I have compiled it, and no errors were found... How can I do this compact and repair thing??? The strangest thing is that it happens sometimes, and sometimes not... so so so so so strange... And I don't were to look for it, and how to solve it...

The error I get is following, however I don't get an error number: "Microsoft Office has encountered a problem and needs to be closed. " If I press debug it says: The instruction at "0X6508baa8" referenced memory at "0x00000023". The momory could not be "read". Any idea?

Why does it happen?? I imported all the forms into a new version of my program (so new db), and it worked fine all the morning, but now again... I do not get it?? What's wrong?? I did not change any part of the code... May it be because access is not designed to make beatiful forms?? I'm...

Hello all! My program was almost finished, and everything was just fine when a fatal error occurred! I tried to open my access application and my startup page appears, when i introduce the values I need to introduce here (username and password), a microsoft screen appears, saying that the...

I know it may be wrong... but i'm comparing it as string (as I have it saved in the database as string), then I need it to be the exactly the same... Too late to change it, as the death line is on friday... Do you have any idea?????????????????????????????????? I'm desperate... Thanks!

Hello all! How can I change the one digit number to two digits numbers?? number from 1 to 10... to 01 to 09 to have 2 spaces for number?? By code... I have no clue, and no idea where to start looking for... Thanks in advance!

Hello, i've got a report, and I need to change the value displayed for a field. I mean: in my database i stored a boolean, so in the report it appears as -1,0, I would like it to change for some meaningful word, how can I do it dinamically??? Thanks!

well... I need to create a report that the select depends on what the user introduces... no way to figure out how to do it, i found a solution that was create a query everytime, and create the report by code. More accurate, the report is already created, but I create the data displayed by...

Hello! Thanks for your reply, i've tried and still not working. The thing is that it deletes some controls, but not all of them, so i get an error... The code right now is the following: Dim rpt As Report DoCmd.OpenReport "test4", acViewDesign Set rpt = Reports![test4] Dim c As Control For...

Hey! Not sure what you want to do, but if you want to sum all the values for a row, check this out, it may help. http://support.microsoft.com/kb/328320 Hope this helps! :)

Hey! I need to delete all the controls from a report dynamically, and I've tried the following: DoCmd.OpenReport "myreport", acViewDesign Set rpt = Reports![myreport] Dim c As Control For Each c In rpt rpt.DeleteReportControl rpt.name, c.name Next and it won't work... the following error...

Hey! I've tried the following: DoCmd.OpenReport "myreport", acViewDesign Set rpt = Reports![myreport] Dim c As Control For Each c In rpt rpt.DeleteReportControl rpt.name, c.name Next and it won't work... the following error appears: Run-time error: 2465 application-defined or object...

hello all! How can i delete all the controls from a report by code?? From a form.... should it be something like: for each ctr in reports![ReportName] 'delete control, i don't know the sentence yet.... next

yeah... it works, but the problem is that i don't know in advance the number of fields i'm gonna have. I know the columns, but don't know the rows.... and it's driving me NUTS :eek: and don't know what else to try.... Any suggeriment would be veeeery nice thank you