Search results

I've got a database that many users here use that uses the Environ() command to identify the user. There are a few computers that come up with the error "Undefined Function 'Environ()' " when they load the database. What's confusing is that all the computers here are ghosted off the same...

I need to figure out how to automatically insert the next record number when someone hits New in a form to add a record. Easy enough.. Autonumber, right? Nope.. the field they're using in this database is setup as Text and there are a couple of records that have letters in the field. I don't...

I have an existing table that currently looks like this: Product Month Number Sales cogs 1 245 cogs 2 324 sprockets 2 352 sprockets 1 123 I want to use a make table query to convert the table to...

How do I reference a field that ends with a # symbol? For example My Field # I tried My_Field_#.Text but it didn't like that. I checked what Access called it if I tried to make that field an event. It made it My_Field___BeforeUpdate. I tried variations of that, but couldn't get it to...

I need my database to create a custom report number for sumbitting samples. The standard that they use is YY-MM-## where ## is a sequential number based on how many samples have been submitted that month. For example, The first sample submitted this month is 03-09-01, next is 03-09-02, and so...

I've got 2 tables.. One with sales history and one with sales forecast. I'm trying to use a query to combine them. I've got joins set up with the common info (customer name, product) so it shows me history and forecast info at the same time in the result. My problem is that we have some...

I have a query that adds 12 months of forecast data, but some of the data contains nulls. The problem is that if any one of the 12 months contains a null it makes the result null. Is there an easy way to make it look at the nulls as zeros? The data is on a SQL server, so I have no control of...

I have a form based on a query that changes based on combo boxes on the form. When I changed the selection in the combo box the data in the rest of the form wasn't changing based on the query. I tried putting me.refresh and me.requery in the After Update event of the combo box. I thought my...

I want to put a field on my form that shows the last person to edit the record (in case someone screws something up). The easiest way to do this that I can think of is to just use VB to grab the name of the computer. How can I do this? Thanks, - Marc

I am making a database of all the computers at my company. It's based on the Dell service tag and includes everything about the computer, cpu, ram , hd, repair history, assigned user, etc. I want to be able to switch back and forth between 2 forms. One form (frmAssetViewer) is a detailed view...

I'm working with a database I inherited. Most tables are on an SQL server. I need to add on to a form, so I had more fields added to the main table on the SQL server. The form is based on a query, so next I went to the query and added the fields that I had added to the table. If I run the...

I've got a combo box in a form that uses a query to display a table in a sub form. One of the option in the combo box is all. I'm trying to write an if statement in the criteria for the query so that it either show what is a match for what is selected in the combo box, or it shows all if all...

I have an existing database that has self contained tables. I found a table on an SQL server in the company that has better info and can replace one of my existing tables. The problem is that a couple of the field names are different. This is a pretty big database (lot of forms and code...

I've got a pretty simple query that's giving me trouble. Attached is a picture of it: Basically I have 2 columns that are Sums. The 3rd column is an expression that divides one sum by the other. It was working fine until I went back and added labels to the first 2 columns (Sales and Price...

I want to make several forms that will be very similar and use information from the same table. I would like to create a list of option buttons (one for each form) so the user can click on a button to switch to a different form. The other form would be another way look look at the same data...