Search results

Hi all, I am stuck with one issue on my access migrated to sql backend. It was suggested that apart from migrating the access tables to the Sql backend I should create a ODBC connection from the access front end to the SQL server (2010). I recently updated the license of the server...

hi all, I have completed migration of my Access DB to SQL server with Access as my Front End :( (Department decision). Now i am having an issue with a Calculated field in a key table. I know Calculated fields do not work in SQL and have been trying to find a way to work around this. The...

Hi all, I have a complex Access database with a lot of Subforms and related tables. It is used by atleast 10 people with minimum of 3 users in there at the same time. The database is growing and causing problems. the IT team at my company suggested i migrate the data to SQL backend. Now...

Hi, so i have this database that has unbound forms and unbound subforms (not my choice but, have to go with it). So i have a subform that has a listbox that pulls out a list of vendors from table1 which is store in subform1. Now this subform: subform 2 records the vendor's license info...

Hi all , I am struggling with a set of VBA coding that a previous person on the project was using. I am fixing their mess and i cannot for nuts figure out why the error comes up. So let me describe what i am trying here. There is a parent table with basic information about each...

hi everyone, I have a Access 2010 database with multiple unbound form and subforms. One subform has a list box that lists all personal name and role. the personal information is stored on the same subform itself.image is attahced. I have been wondering and trying to fix the Run-Time Error 2452...

Hi I am stuck here and not able to find the reason why my Save button is not working here. If i enter a new value/ update any value the appropriate message box pops up but, the data is not actually saved. can you please help? '------------------------------------------------------------ '...

So i have a Calculated field in a table :( which is an expiration date. It adds two years to another field. Both field are on a Form. Now ppl come by and ask me to make the calculated field editable because some of the expiry dates are not necessarily 2 years. How do i change this?? do i need...

Hi all, I am going :banghead: with this issue. I have one table containing name of restaurant with its address etc. Then i created another table to list out the restaurant workers names and details. Just as an example, Table:Restaurant Restaurant name Address line 1 Address line 2...

Hi I don't know if this is possible with VB but, here it goes. I have a data base with names, email IDs, phone numbers of 5 types(example quality, security, IT,finance etc) of person from ten different project teams. I created a basic form for the end user to enter values and created fields for...

Hi, I have a table from which i pull out a few fields into the query like name number etc. Now i did not create a field for email. I want to create a query in which if the name is "x" i need a new field in the query to read 'x@gmail.com". can some one help me. SELECT Books.ID...

Hi all, This is my first post and i am relatively new to access so please be patient with me. i have been searching for an answer to my question on your forums for a long time and don't seem to find an exact answer.So here is my problem. I have a backend database with some vendor...

Hi friends I am relatively new to access VB programming. I have basic C and C++ and will understand programming jargon. please help me out :)