Search results

Hello everyone, I have been working with Access for some years now and I have created a few interesting and beneficial dbs for the company. I started with single user db, then multi user, then front-end and back-end dbs. I initially got started thanks to this forum and I don't think I would...

Hello everyone, I have been tasked to create a Web Search Emulation of some sort. I'm wondering if I could do it with Access. Any thoughts, suggestions or recommendations are appreciated. I'm thinking if I create a start page with a search field where the user can enter any word they would...

Hello everyone, I have a dilema and I hope someone can help me... I have a simple event on the On Click of a sub-form in datasheet view. When someone single clicks the sub-form I have the following code: This code is sort of a pre-setup for a "Double-Click" which opens an Edit Window that...

Hello everyone, I've tried many things (compact and repair, Nz(,0), sum()) and I can't get it to work. I entered =[field1]+[field2] but it behaves like if I had entered =[Field1] & [Field2]. Yes instead of adding the numbers it just puts them together. For example: Field1=3 and Field2=5...

Hello everyone, I've been seaching this site for some direction on previous posts, but I have not found what I'm looking for. I figure someone might be able to point me in the right direction. I posted in the General Forum because I'm not sure where to post it. I'm working on a scheduling...

Hello everyone, I'm working on an SQL Statment that has a month and year request, but I want to change it to request a date range. The statment is as follows: PARAMETERS [Enter Month] Integer, [Enter Year] Integer; SELECT vWorkOrders.StatusCode AS Status, vWorkOrders.StatusDescription...

Hello everyone, I'm working on a database for a friend that is an older person (technically challenged) and I'm trying to make it as easy aspoisslbe for him. I've run into an issue that I cant figure out how to solve. The following code works perfect (thanks to all the code in this site's...

Hello everyone, I have a database that populates rooms with occupants for classes or meetings. I have two listboxes, one has the potential occupants and the other the list of already assigned occupants to the room. So far so good. Then I have a button that will move any one selection on the...

Hello Everyone, I have the following code that I think is good, but does not seem to work: Dim db As Database Set db = CurrentDb db.Execute ("UPDATE PubStatus SET [PubCode]='" & PUB & "' WHERE [PubStatusID]=" & 1 & ";") db.Execute ("UPDATE PubStatus SET [PubCode]='" & AUX & "' WHERE...

Hello Everyone, I'm working with this code (same as earlier post), bur different error: Dim rst As DAO.Recordset Dim db As DAO.Database Dim ctl As Control Dim varItem As Variant 'On Error GoTo Err_btnAceptar Set db = CurrentDb()...

Hello Everyone, I'm having an issue with this code: Dim rst As DAO.Recordset Dim db As DAO.Database Dim ctl As Control Dim varItem As Variant On Error GoTo Err_btnAceptar Set db = CurrentDb() Set rst =...

Hello All, I'm currently working on a database for a friend. The database is for a Club Membership. It's not complete yet, but this is what I have so far. I had to remove the graphics to comply with the upload size. I was wondering if anyone would like to take a look at it and let me know...

Hello Everyone, A bit of background: I'm working on a database for a friend. She has a Gym and she would like to change from manual labor to automation. So I'm creating a Club Membership/Fee/Payment/Invoice tracking database. So far everything is good. I have created a membership table...

Hello everyone, Using Acess 2007 This is what I have: I have one Query with the following: Main.ID, Main.First Name, Main.Last Name, Main.Assigned Date I created a Daily Report using this Query to tell me when I need to meet again with these people. I have a Report that has the following...

Hello everyone, I have MS SQL 6.5 for NT installed on an NT server and I have the SQL Enterprise Manager installed. I'm new to Access and this is my first try at understanding SQL 6.5. Where can I find the Relationship window within SQL Enterprise Manger? Is it called something else or am I...

Hello everyone, I have a dilema. I'm loosing a front end application that manipulates an SQL database. I'll be able to keep the SQL server and data, but I can't keep the front end app. What do you recomend I do. Should I export all the data from the SQL server and create an MS Access...

Hello all active members of this forum, Like I stated on the title, this forum got me into trouble. By following the reading in this forum and some recommendations from the regular users I have created thre database for the place I work at. now they want me to be the official DB admin! :eek...

Hello everyone, Can I ask you to critique my database sample? I'm working on a multilingual database and I'm trying to figure out how to do it best. I found a couple of ideas on this forum but nothing that would help me completely. I uploaded a sample of what i have come up with. Just...

Hello everyone, I'll start by saying that this is my first DB.. :eek: I'm having a bit of a problem trying to get this to work maybe someone can give me some direction. What I'm trying to do: I want my main form to show a query result of work orders that are active. This is the code that I'm...

Hello Everyone, I've been looking at all the fine db samples and advice provided in this forum and they are giving me a huge boost in my new job as a DB Admin. :D Since this forum has a very active group and you guys know and done it all, ;) I thought I would ask if anyone out there has done...