Search results

My company is changing phone systems this week. Some people already have direct dial phone numbers with our old system that we are trying to port over to the new system. With this new system however all of the people who don't currently have a DID number will be getting one. We are trying to...

I have a database where I created a log in form for the users where they select their name and enter a case sensitive password. We have just figured out that when we record a new password on the password table it is automatically capitalizing the first letter of the password. I don't want it to...

I don't know if this is the correct sub forum for this question. So I have a database, that multiple people have access to over a VPN. For some people everything works fine, but for others some of the forms will not load. It will just show a blank page for some of the forms. I can put those...

I would like to query a list box refining the search using a drop down menu. When on the first option (Which is blank) I would like to see all items in the list box, but when I select a name from the combo box I want it to refine the search using whatever is selected. I have tried a lot of...

I have a list box that I would like to make searchable. What I would like to have is when nothing is in the "Search Box" the list box shows all entries but when the "Search Box" has something in it and the person presses the Search Button it brings up the results in the list box. I only know...

I have a query that has one column that groups names together, a second column that sums up the quantity of how many total units someone has received, and then a third column that has purchase dates in it that is set to "where". I am trying to set a criteria in the date column to show results...

Hey, I have a list box on a form that I would like to ba able to sort either by the person's name, receipt number, or by transaction date. I had found another forum post that suggested the person change the row source using vba when a button is pressed. I tried this method and it worked until I...

Hey, I'm trying to reference some information that is on a form using query but for some reason I can't. If I reference any fields in the form using a query I'll get random things like Chinese characters, blank fields, or for one of the number fields on the form will return "q" in a query. I...

This is an odd one to me. I have an append query that appends 3 fields on a form to a table. It has been working well since I made if several months ago, up until I tried run it tonight. It will recognize 1 of the 3 fields with the correct value, 1 of the fields will have some funky Chinese...

I have a report that I have to run that is supposed to show a list of 4 digit codes. However if the code happens to start with zeros it will not display them. Example if the code is "0062" it will only show as "62" but I need it to show all 4. I've tried to use input masks but other than that I...

I have a query that I want to be able to export to an excel spreadsheet with the date appended to the file name and then also auto-format the spreadsheet. I can get the export and the date to append just fine using this module Public Sub AutoExportReceipts() DoCmd.TransferSpreadsheet acExport...

So I am not very good at writing criteria. I have a column where I would like to total the number of payments made by a client for the previous week. Here is what I have so far. DSum("Payment_RentTransaction","TblRent_Report","ID_Number=" & [QryClient_CurrentResidents]![ID_Number]) That's just...

Hey, I'm trying to use an aggregate function inside another aggregate function and I'm having a difficult time. I don't really know what all I need to put in here. Here is what I have: dlookup("Amount_Owed", "TblRent_OwedAtDischarge", "ID_RentOwed = " & DMax(""ID_RentOwed""...

I'm sure this is a round about way of doing something simple but it's my first time trying something like this and it's the best I could come up with. I have to append to and update 5 fields ("Resident", "Meeting Date", "In House", "Outside", and "WHU") in a table named "Meetings". The record...

I have two issues I'm running into tonight. Using a continuous form I've created a basic roll call where I am able to enter the date of a class and track how many classes each client attended using an append query. The clients ID #'s are being pulled from their info on one table (where most of...

I'm very new to access and I've tried looking on the internet on how to do that but I can't quite find what I'm looking for. Here's what I have: A table that hold my client's info [residents] A form that searches all of the records [search_form] and 3 forms to enter in the client's information...

Hey Everyone, I'm very new to the whole Access thing. I've tried messing around with it in the past but didn't get far. I made my first working database for my work at the beginning of the year and it's been evolving slowly as our needs have changed. I don't really know anything about writing...