Search results

Hello everyone. I have a pretty big program written in C#, it has been running alive and well but recently I decided to password lock my .accdb file. Everything works except crystal reports. I went into set datasource location and tried to update my existing connection string to each report by...

I am trying to create a query that takes all of my tables and combines them all into one query. I am not sure if this would be acceptable. I am getting an error of "The number of columns in the two selected tables or queries of a union query do not match." SELECT tblJuveniles.* FROM...

Hello, I have a very complex relationship of about 10 tables with many, many to many relationships. For some reason I am having a hard time getting the PK in one table to fill in the FK in another table. For example, IF my PK in the first table is an autonumber and i fill in a persons name I...

I need some help on creating one single data entry form for the relationship I have attached. I feel that I can not get my mind wrapped around this or how to do it. Previously I had three tables but found out I could normalize even further hence this is what I have so far and is also the reason...

Hello I have a simple question. Lets say I have a table of employees and a table of their siblings set up as a one to many relationship One:employee======>Many:siblings If I have a data entry form to create new records, how would I add more than one sibling per employee if they have one? At...

Hello everyone, I am creating a database for a local police department. The database is supposed to contain info related to juvenile's, their offenses, home situations, and cases. I have a normalized setup which currently includes 3 tables. One table is the "Home Bio" table which contains...

Hello everyone, I am trying to create a report in which it is populated by only the current month's population of juvenile detainee's. I need to have a field in this report that basically numbers each juvenile. EG: Line| Last Name| Middle Initial| FirstName 1 | Doe | John...

Hey guys, I am trying to call a function that I made when a form is opened. I then want the function return value to populate into a textbox on that form. I know this is very simple because I know C#; however, I am new to VBA and I just cant seem to get this to work. Basically I am trying to...

Hello I am trying to connect a database search form to a query I made. I have put in some code in the criteria sections of the fields that I want to search. Of course these fields are referenced to their respective text boxes and submit button. It works perfectly unless one of the fields with in...

Is there anyway to auto populate a field in one table to a field in another table?

My name is George, I'm pretty new to Access and VBA and thus have stumbled upon this forum. Due to my background in C# I have been asked to be head dev at my job at creating databases. We are currently working on some software for a local police department. I will probably be needing some help...

Hello everyone, I am trying to create a database for juvenile processing in a local police station. I am having trouble trying to make a query that pulls together all the info from 5 tables that I have and using that query as the source for a main dataEntry form. The guy working on this database...

Hello everyone, I am fairly new to Access and have been put on a project at my job to create a database for a local police station. I have good knowledge in C#; however, not much in VBA or SQL. I am having a problem here that I hope someone can help me with and with as much detail as possible...