Search results

I have a control box I want to populate with the first day of the year. You have to pick a year form a list and then I need it to show the first day of the year no matter what year is picked. Just can't figure it out. I'm hoping once I get shown how to get the first day I can use the little...

I am trying to get the data from table A into table AA. Not sure how this works. Tried queries, but no luck. Thanks for any ideas or help.

Hello: I was handed a table where the data is layout like this: Field 1 Field 2 Field 3 00050S 10-71434B 0.05 00050S 10-72855 0.003125 00050S 10-83105-6A 1 00050S 10-83126 1...

Hello: I have a need to strip off the last digit on a group of numbers: Example: 0871 --- Just remove the one 13463 --- Just remove the three and so forth. I have tried Mids,Lefts,Rights and some combination of those, but I cannot get it to work. thank you

I have a sequence of numbers like 08123, 0912345, and 0712. The first two are the year and the next numbers is just a counter that adds one each time data is entered. I now need to seperate the years from the numbers, but the last digits can have two digits, three digits or more. I have...

I have a form in Excel with a command button on it. Is there a way to make it print out a report that is in Access. The reason I need to do this, the windows based scanners I have do not handle Access, most scanners don't so I thought since it can open an Excel spreadsheet, could I just put a...

Attached please find three databases. Two are programs, one is data. One program is stand alone and when you scroll through the records on frmSwageLogEntries, the control CFSNumID shows data. When the two are linked,when you scroll through the data CFSNumID shows nothing. I'm baffled.

Hello I have data say enter into twelve controls and after the last item is enter is there a way to compare them against one another to find the larger and smaller numbers without a ton of "IF" statements. I would like to then subtract the two. I tried Dmax and a few other combinations, but...

Is there a way to say put a button on a web page and then have it run a vba code in access to say print out a report that is kept in the access database. I'm really new at web pages. thanks

Hello I know this solution has been posted before and I searched to know avail. I print out a group of cards with the same information through a vba loop and would like the bottom to show Card 1 of whatever the total of card there are. I cannot use Page of , because it just show, Page 1 of 1...

Hello: I have a number letter combination I trying to use the last 5 digits. Example Right( "1234E5678",5) which returns E5678 just fine. The problem is I'm converting this to a barcode and only need numbers. I tried Val in front but it returns the same value when the numbers are close...

I have a record in one table that has many records in another table and I would like to display them like this Header of form main record number (one to the many) Detail of form Information one Information two Information three Information four Information five...

I have a form in datasheet view and when I click on any record the scroll bars disappear. I cannot get them back until I reopen the form. Whats going on?

I have a form say with a control called route. What I have been trying to do is print out report for each route. (I have a different report for each route) I have a command button on the form with if statements, but it prints all the records from the the form to whichever If statment is true...

I need to randomly audit parts in a warehouse. I have the code to grab random records. No problem there. The problem is the part might have mutiple locations, so I need a way to grab a random part and then check to see how many locations it's in and make sure it grabs all other locations that...

I'm trying to modify a query in project but I get this Error and not sure where or how to fix this problem. I've been searching Microsoft Web Site. You have connected to a version of SQL Server later than SQL Server 2000. The version of Visual Studio or Access that you are using was released...

I have a query where I need to use last record, but the problem is this prevents the records form being updatable. Add / Update / Delete. Query is the recordsource for a form. I have tried sub queries, seperate and in the exsiting query to no avail. Any guidence would be apprecited. thx...

Hello: I have a form that has tabs on it. I have a list box on one of the tabs linked to a query, trying to show only those records that go with the person's name on the header of the form. Example in query: =[forms]![frmContacts]![Page]![4].[id] -- [id] is the person number. This is were...

I been trying to nest if statments and vlookups to find values from various coulums with no luck. See attached spreadsheet. See sheet Prod cell H2 to give you an idea. The data is on the shipschd sheet, which is downloaded from an As400 system. Any idea's or help! Thanks dmh

Combining Queries The goal was to track equipment downtime, by each piece of equipment, but the WC might have multiple downtimes on multiples equipment each day. So you end up with equipment numbers in different parts of the table.(mach # 1234) I’ve been trying to figure out how to combine...